Skip to content

Instantly share code, notes, and snippets.

@mattm

mattm/two-table-join.sql

Last active May 22, 2018
Embed
What would you like to do?
SELECT
users.user_id,
COUNT(DISTINCT post_id) AS post_count,
COUNT(DISTINCT page_id) AS page_count
FROM users
LEFT JOIN posts ON posts.user_id = users.user_id
LEFT JOIN pages ON pages.user_id = users.user_id
GROUP BY 1
+---------+------------+------------+
| user_id | post_count | page_count |
+---------+------------+------------+
| 1 | 3 | 0 |
| 2 | 2 | 2 |
| 3 | 0 | 5 |
+---------+------------+------------+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.