andrey_vetrov

Untitled

Apr 3rd, 2022 (edited)
58
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.10 KB | None | 0 0
  1. -мой код, его не пропускает тренажер
  2. SELECT customer_id,
  3. total,
  4. invoice_date,
  5. EXTRACT(WEEK FROM CAST(invoice_date AS timestamp)),
  6. DATE_TRUNC('month',CAST(invoice_date AS timestamp))
  7. FROM invoice
  8. WHERE (customer_id BETWEEN 20 AND 50)
  9. AND EXTRACT(WEEK FROM CAST(invoice_date AS timestamp)) IN (5,7,10,24,48);
  10.  
  11. --код сокурсника, который мне прислали, у сокурсника - проходит, у меня код сокурсника - не проходит
  12. --код сокурсника, который пропустил тренажер
  13.  
  14. SELECT customer_id,
  15. invoice_date,
  16. total,
  17. DATE_TRUNC('month', CAST(invoice_date AS timestamp)),
  18. EXTRACT(WEEK FROM CAST(invoice_date AS timestamp))
  19. FROM invoice
  20. WHERE customer_id BETWEEN 20 AND 50
  21. AND EXTRACT(WEEK FROM CAST(invoice_date AS timestamp)) IN (5, 7, 10, 24, 48);
  22.  
  23. ссылка на задачу https://practicum.yandex.ru/trainer/sql-data-analyst/lesson/5b182308-ce23-4db5-a6f8-39428d776081/task/0751fe2e-12bb-4b61-af4b-4cd9a88749ad/?hideTheory=1
  24.  
Advertisement
Add Comment
Please, Sign In to add comment