Advertisement
Step8rother

Применение агрегирующих функций, задача 2

Jun 24th, 2023
949
0
Never
1
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.20 KB | Source Code | 0 0
  1. SELECT CAST(invoice_date AS DATE),
  2.        customer_id,
  3.        total
  4. FROM invoice
  5. WHERE EXTRACT(MONTH FROM CAST(invoice_date AS TIMESTAMP)) = 9
  6.         AND customer_id IN (11, 13, 44, 36, 48, 52, 54, 56)
Advertisement
Comments
  • Step8rother
    1 year
    # text 0.37 KB | 0 0
    1. Дополните запрос. Оставьте в таблице поля с идентификатором покупателя (поле customer_id), датой заказа без времени (поле invoice_date) и суммой заказа (поле total). Выберите покупателей с идентификаторами 11, 13, 44, 36, 48, 52, 54, 56.
Add Comment
Please, Sign In to add comment
Advertisement