andrey_vetrov

Untitled

Apr 5th, 2022
34
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.42 KB | None | 0 0
  1. https://practicum.yandex.ru/trainer/sql-data-analyst/lesson/1b657bc5-b116-424e-89eb-ebb059081b1f/task/7f0c0bf1-78fc-4c4e-bd10-bc90b9e48f18/
  2.  
  3.  
  4. SELECT *
  5. FROM
  6. (SELECT billing_country,
  7. AVG(total)
  8. FROM invoice
  9. WHERE EXTRACT(YEAR FROM CAST(invoice_date AS timestamp)) = 2009
  10. AND EXTRACT(MONTH FROM CAST(invoice_date AS timestamp)) IN (2, 5, 7, 10)
  11. GROUP BY billing_country) AS billing_country_avg
Advertisement
Add Comment
Please, Sign In to add comment