inner-join join cross-join MySQL on-clause
join cross-join inner-join
limit-keyword TOP-clause ROWNUM
TOP-clause SQL-server
MySQL limit-keyword
ROWNUM Oracle
WHERE-clause operators
HAVING-clause GROUP-BY-clause aggregate-functions
HAVING-clause COUNT-Function aggregate-functions