Skip to main content

5

sql

-- View all clients
SELECT *
FROM clients;

-- Group by region to see total sales
SELECT region, SUM(sales) AS total_sales
FROM clients
GROUP BY region;

-- Keep only regions with total sales over 25000
SELECT region, SUM(sales) AS total_sales
FROM clients
GROUP BY region
HAVING SUM(sales) > 25000;

-- Show average sales per region
SELECT region, AVG(sales) AS avg_sales
FROM clients
GROUP BY region;

-- Keep only regions with average sales at least 6000
SELECT region, AVG(sales) AS avg_sales
FROM clients
GROUP BY region
HAVING AVG(sales) >= 6000;

-- Combine conditions:
-- total sales over 25000 AND average sales at least 6000
SELECT region,
       SUM(sales) AS total_sales,
       AVG(sales) AS avg_sales
FROM clients
GROUP BY region
HAVING SUM(sales) > 25000
   AND AVG(sales) >= 6000;

Want to learn more?

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

sql