blob: 5f9f7af02fc7b8de8635c43af2066fb409a97ae2 (
plain)
1
2
3
4
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%'
|
