From c9b6b9a5ca082fe7c1b6f58d7713f785a9eb6a5c Mon Sep 17 00:00:00 2001 From: Martial Simon Date: Mon, 15 Sep 2025 01:08:27 +0200 Subject: add: graphs et rushs --- graphs/sql/fast_and_murderous/req01.sql | 2 ++ graphs/sql/fast_and_murderous/req02.sql | 2 ++ graphs/sql/fast_and_murderous/req03.sql | 3 +++ graphs/sql/fast_and_murderous/req04.sql | 2 ++ graphs/sql/fast_and_murderous/req05.sql | 2 ++ graphs/sql/fast_and_murderous/req06.sql | 5 +++++ 6 files changed, 16 insertions(+) create mode 100644 graphs/sql/fast_and_murderous/req01.sql create mode 100644 graphs/sql/fast_and_murderous/req02.sql create mode 100644 graphs/sql/fast_and_murderous/req03.sql create mode 100644 graphs/sql/fast_and_murderous/req04.sql create mode 100644 graphs/sql/fast_and_murderous/req05.sql create mode 100644 graphs/sql/fast_and_murderous/req06.sql (limited to 'graphs/sql/fast_and_murderous') diff --git a/graphs/sql/fast_and_murderous/req01.sql b/graphs/sql/fast_and_murderous/req01.sql new file mode 100644 index 0000000..ac044ad --- /dev/null +++ b/graphs/sql/fast_and_murderous/req01.sql @@ -0,0 +1,2 @@ +SELECT person_id,case_id,content FROM justice.testimonies +WHERE content LIKE '%Nexus N%' diff --git a/graphs/sql/fast_and_murderous/req02.sql b/graphs/sql/fast_and_murderous/req02.sql new file mode 100644 index 0000000..2caffa9 --- /dev/null +++ b/graphs/sql/fast_and_murderous/req02.sql @@ -0,0 +1,2 @@ +SELECT person_id,case_id,content FROM justice.testimonies +WHERE content LIKE '%Nexus __%' diff --git a/graphs/sql/fast_and_murderous/req03.sql b/graphs/sql/fast_and_murderous/req03.sql new file mode 100644 index 0000000..4ae4836 --- /dev/null +++ b/graphs/sql/fast_and_murderous/req03.sql @@ -0,0 +1,3 @@ +SELECT T.person_id,C.id,T.content,C.description FROM justice.testimonies AS T,justice.cases AS C +WHERE T.content LIKE '%Nexus N3%' + AND C.description SIMILAR TO '%(speeding|speed|fast|reckless)%' AND T.case_id = C.id diff --git a/graphs/sql/fast_and_murderous/req04.sql b/graphs/sql/fast_and_murderous/req04.sql new file mode 100644 index 0000000..d2f6e0c --- /dev/null +++ b/graphs/sql/fast_and_murderous/req04.sql @@ -0,0 +1,2 @@ +SELECT name FROM nexus_stores.products +WHERE name ILIKE '%apple%' diff --git a/graphs/sql/fast_and_murderous/req05.sql b/graphs/sql/fast_and_murderous/req05.sql new file mode 100644 index 0000000..4dc8233 --- /dev/null +++ b/graphs/sql/fast_and_murderous/req05.sql @@ -0,0 +1,2 @@ +SELECT I.receipt_id,P.name,I.quantity,P.price FROM nexus_stores.products AS P,nexus_stores.receipt_items AS I +WHERE I.quantity > 10 AND P.name ILIKE '%apple%' AND I.product_id = P.id diff --git a/graphs/sql/fast_and_murderous/req06.sql b/graphs/sql/fast_and_murderous/req06.sql new file mode 100644 index 0000000..5f9f7af --- /dev/null +++ b/graphs/sql/fast_and_murderous/req06.sql @@ -0,0 +1,5 @@ +SELECT DISTINCT R.purchase_date,R.first_name,R.last_name,R.email,P.name,P.price,P.category FROM nexus_stores.receipts as R,nexus_stores.products AS P,nexus_stores.receipt_items AS I +WHERE R.email SIMILAR TO 's(a|e)m[a-z]{3,6}\_w[a-z]{6}[0-9]*@roger\_[a-z]+.[a-z]{3}' +AND I.receipt_id = R.id +AND I.product_id = P.id +AND P.name ILIKE '%apple%' -- cgit v1.2.3