View difference between Paste ID: tHPXWHCu and uzte4p8G
SHOW: | | - or go back to the newest paste.
1-
SELECT customer_id,
1+
SELECT *
2-
       invoice_date,
2+
3-
       total,
3+
WHERE EXTRACT(DAY FROM CAST(invoice_date AS TIMESTAMP)) IN (1);