Join and aggregate child rows

sql

SELECT u.id, u.email, COUNT(o.id) AS order_count
FROM users u
LEFT JOIN orders o ON o.user_id = u.id
GROUP BY u.id, u.email;

Explanation

A classic reporting query for dashboards and admin pages.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Same sheet · prioritizing joins

Return rows where both tables match.

Open In sheetsqlsame section

Return all rows from the left table and matching rows from the right table.

Open In sheetsqlsame section

Join a table to itself using aliases.

Open In sheetsqlsame section

Compute an aggregate once and join it back.

Open In sheetsql1 tag match

Return users who have at least one paid order.

Return users who have orders.