Skip to main content

7

sql

-- View all client orders
SELECT *
FROM client_orders;

-- Use WHERE to filter individual rows before grouping
SELECT client_name, region, order_total
FROM client_orders
WHERE region = 'USA';

-- Use HAVING to filter groups after aggregation
SELECT region, AVG(order_total) AS avg_order
FROM client_orders
GROUP BY region
HAVING AVG(order_total) > 200;

Want to learn more?

Join CodeFriends Plus membership or enroll in a course to start your journey.

sql