limit-keyword TOP-clause ROWNUM
operators logical-operators
NULL-values unique-key primary-key constraints
sub-queries correlated-subquery synchronized-subquery
join inner-join
sub-queries
HAVING-clause COUNT-Function aggregate-functions
SELECT-clause
COUNT-Function AVG-Function MIN-Function LAST-Function FIRST-Function MAX-Function aggregate-functions SUM-Function
CASE-Function