Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT CAST(invoice_date AS DATE),
- customer_id,
- total
- FROM invoice
- WHERE EXTRACT(MONTH FROM CAST(invoice_date AS TIMESTAMP)) = 9
- AND customer_id IN (11, 13, 44, 36, 48, 52, 54, 56)
Advertisement
Comments
-
- Дополните запрос. Оставьте в таблице поля с идентификатором покупателя (поле customer_id), датой заказа без времени (поле invoice_date) и суммой заказа (поле total). Выберите покупателей с идентификаторами 11, 13, 44, 36, 48, 52, 54, 56.
Add Comment
Please, Sign In to add comment
Advertisement