A.GROUP BY B.order by C.limit D.union
A.LEFT OUTER JOIN B.RIGHT OUTER JOIN C.NATURAL JOIN D.INNER JOIN