Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT MIN(total),
- MAX(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
-
- Дополните запрос. Найдите минимальное и максимальное значения поля total. Условия для среза остаются прежними.
Add Comment
Please, Sign In to add comment
Advertisement