Skip to content
RED SAGSkills
easy5 pts · first answer countssqlaggregation

Why this GROUP BY fails

This query gives an error in PostgreSQL. Why?

SELECT city, customer_name, SUM(amount)
FROM orders
GROUP BY city;
Choose one answer