SELECT customer_id,
SELECT *
invoice_date,
total,
WHERE EXTRACT(DAY FROM CAST(invoice_date AS TIMESTAMP)) IN (1);