DB2 - Write down the syntax order & execution order of SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY& FETCH FIRST clauses

Answer:

SYNTAX ORDER
============
SELECT FROM WHERE GROUP BY
HAVING
ORDER BY FETCH FIRST


EXECUTION ORDER
===============
FROM
WHERE
GROUP BY
HAVING
SELECT
ORDER BY
FETCH FIRST