Advertisement
Guest User

Untitled

a guest
Feb 29th, 2020
86
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.25 KB | None | 0 0
  1. SELECT
  2. CUST_COUNTRY,
  3. SUM(PAYMENT_AMT) AS total,
  4. MIN(PAYMENT_AMT) AS min_amount,
  5. MAX(PAYMENT_AMT) AS max_amount,
  6. AVG(PAYMENT_AMT) AS avg_amount
  7. FROM
  8. customer
  9. WHERE
  10. CUST_COUNTRY LIKE 'Georgia%'
  11. GROUP BY
  12. CUST_COUNTRY
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement