Joins

In plain English

Join tables on keys and check cardinality.

• Use INNER and LEFT JOIN.
• Alias tables.
• Use EXISTS for semi-joins.

SELECT c.title, COUNT(l.id) AS lessons
FROM courses c
LEFT JOIN lessons l ON l.course_id = c.id
GROUP BY c.id, c.title;