тема 2 урок 11 задача 2

SELECT customer_id,
       invoice_date,
       total,
       DATE_TRUNC('year', CAST(invoice_date AS timestamp)),
       EXTRACT(WEEK FROM CAST(invoice_date AS timestamp))
FROM invoice
WHERE customer_id BETWEEN 20 AND 50;