Advertisement
Step8rother

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

Jun 24th, 2023 (edited)
488
0
Never
1
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.17 KB | Source Code | 0 0
  1. SELECT MIN(total),
  2.         MAX(total)
  3. FROM invoice
  4. WHERE EXTRACT(MONTH FROM CAST(invoice_date AS TIMESTAMP)) = 9
  5.   AND customer_id IN(11, 13, 44, 36, 48, 52, 54, 56);
Advertisement
Comments
  • Step8rother
    1 year
    # text 0.19 KB | 0 0
    1. Дополните запрос. Найдите минимальное и максимальное значения поля total. Условия для среза остаются прежними.
Add Comment
Please, Sign In to add comment
Advertisement