diff options
Diffstat (limited to 'graphs/sql/fast_and_murderous')
| -rw-r--r-- | graphs/sql/fast_and_murderous/req01.sql | 2 | ||||
| -rw-r--r-- | graphs/sql/fast_and_murderous/req02.sql | 2 | ||||
| -rw-r--r-- | graphs/sql/fast_and_murderous/req03.sql | 3 | ||||
| -rw-r--r-- | graphs/sql/fast_and_murderous/req04.sql | 2 | ||||
| -rw-r--r-- | graphs/sql/fast_and_murderous/req05.sql | 2 | ||||
| -rw-r--r-- | graphs/sql/fast_and_murderous/req06.sql | 5 |
6 files changed, 16 insertions, 0 deletions
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%' |