INNER JOIN : order doesn’t matter
LEFT JOIN RIGHT JOIN : order matters (fill the right extra item with NULL for left join and vice versa for right join)
FULL JOIN (outer join): fill NULL for all dismatching items
GRUOP BY
HAVING
COUNT, SUM, MIN, MAX, etc.