When use subquery vs JOIN?

Subquery vs JOIN

Joins often optimize better and are clearer for relational data. Subqueries shine for existence checks (NOT EXISTS) or scalar aggregates.

SELECT name FROM students s
WHERE EXISTS (
  SELECT 1 FROM placements p WHERE p.student_id = s.id
);