View difference between Paste ID: uzte4p8G and S6tLypH4

 SELECT customer_id,
        invoice_date,
        total,
        DATE_TRUNC('month', CAST(invoice_date AS timestamp)),
        EXTRACT(WEEK FROM CAST(invoice_date AS timestamp))
 FROM invoice
-WHERE(customer_id BETWEEN 20 AND 50);
+WHERE customer_id BETWEEN 20 AND 50
 AND EXTRACT(WEEK FROM CAST(invoice_date AS timestamp)) IN (5, 7, 10, 33, 48);