Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -мой код, его не пропускает тренажер
- SELECT customer_id,
- total,
- invoice_date,
- EXTRACT(WEEK FROM CAST(invoice_date AS timestamp)),
- DATE_TRUNC('month',CAST(invoice_date AS timestamp))
- FROM invoice
- WHERE (customer_id BETWEEN 20 AND 50)
- AND EXTRACT(WEEK FROM CAST(invoice_date AS timestamp)) IN (5,7,10,24,48);
- --код сокурсника, который мне прислали, у сокурсника - проходит, у меня код сокурсника - не проходит
- --код сокурсника, который пропустил тренажер
- 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
- AND EXTRACT(WEEK FROM CAST(invoice_date AS timestamp)) IN (5, 7, 10, 24, 48);
- ссылка на задачу https://practicum.yandex.ru/trainer/sql-data-analyst/lesson/5b182308-ce23-4db5-a6f8-39428d776081/task/0751fe2e-12bb-4b61-af4b-4cd9a88749ad/?hideTheory=1
Advertisement
Add Comment
Please, Sign In to add comment