SQL Generation

Show the total sales revenue (total_revenue) per branch (branch_name)

SELECT d.name AS branch_name, SUM(s.sale_price) AS total_revenue FROM sales s JOIN dealerships d ON s.branch_id = d.branch_id GROUP BY d.name;

SELECT d.name AS branch_name, COALESCE(SUM(s.sale_price), 0) AS total_revenue
FROM dealerships d
LEFT JOIN sales s ON d.branch_id = s.branch_id
GROUP BY d.name
ORDER BY total_revenue DESC;