Skip to main content

9

sql

-- View all client orders
SELECT *
FROM client_orders;

-- Rename a result column using AS
SELECT AVG(order_total) AS average_order
FROM client_orders;

-- Alias without AS (still works, but less clear)
SELECT AVG(order_total) average_order
FROM client_orders;

-- Label multiple columns and group by region
SELECT region AS client_region,
  COUNT(*) AS total_clients,
  SUM(order_total) AS region_revenue
FROM clients
JOIN client_orders ON clients.id = client_orders.client_id
GROUP BY region;

-- Use descriptive table aliases
SELECT client_data.name, order_data.order_total
FROM clients AS client_data
JOIN client_orders AS order_data ON client_data.id = order_data.client_id;

Want to learn more?

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

sql