Recipe
Multiple JOINs
A query isn't limited to two tables. Chain a second JOIN onto the first, and each new table can match against any table already in the query, not just the very first one.
Query
SELECT d.name, d.station, st.name AS lead
FROM dishes d
JOIN stations s ON d.station = s.name
JOIN staff st ON s.lead = st.name
ORDER BY d.name;↓ result
d.name d.station lead
Baklava pastry Yannick
Bifteki grill Giorgos
Dakos salad Sofia
Loukoumades pastry Yannick
Melitzanosalata salad Sofia
Souvlaki grill GiorgosOnce a third table is in, you can filter on any column from any of them, exactly like a two-table join. Here the filter reaches all the way to staff, even though the question is about dishes.
Query
SELECT d.name, d.station
FROM dishes d
JOIN stations s ON d.station = s.name
JOIN staff st ON s.lead = st.name
WHERE st.years > 8
ORDER BY d.name;↓ result
d.name d.station
Bifteki grill
Souvlaki grillThe pattern doesn't change past three tables either: alias each table, join the next one to whichever table already has the matching column, and keep going.