LIKE | Order By | Aggregate Function | Group By | Having | INNER JOIN | LEFT JOIN | RIGHT JOIN | FULL OUTER JOIN