A LEFT JOIN followed by a WHERE condition on the right-hand table’s column can behave like an INNER JOIN.

The logical order of execution is: FROM → WHERE → GROUP BY → HAVING → SELECT

HAVING can be used without GROUP BY, so it is always interchangeable with WHERE

GROUP BY happens before WHERE.