SELECT
<select_list>
FROM
<left_table> <join_type> JOIN <rigth_table> ON <join_condition>
WHERE
<where_condition>
GROUP BY
<group_by_list>
HAVING
<having_condition>
ORDER BY
<order_by_condition>
LIMIT <limit_number>