Lesson 6 of 6

JOIN: link two tables

Data often lives across several tables. JOIN links them: here posts.user_id points to users.id.

SELECT users.handle FROM users JOIN posts ON posts.user_id = users.id finds, for each post, the name of its author.

SELECT users.handle FROM users JOIN posts ON posts.user_id = users.id;

🎯 Your goal

Both tables are provided. Return the handle of members who have a post with more than 50 likes (JOIN + WHERE), sorted by handle.

PRO lesson

This advanced chapter is part of CodeAge PRO. Unlock it to keep your adventure going.