$1.$ FROM

$2.$ WHERE

$3.$ GROUP BY

$4.$ HAVING

They cannot appear in any other order. They don't all have to always be used but they must follow the structure for the ones that are used.

A$)$

I have no information

B$)$

Outer join

C$)$

difference between subqueries and joins

D$)$

Order in which GROUP BY is used

E$)$

Data Definition Language $($DDL$)$