Read the following two statements and choose the best option

Read the following two statements, and choose the best option.

1. A HAVING clause should always appear after the GROUP BY clause.

2. A GROUP BY clause should always appear after the WHERE clause.

Which is true, which is false, are both true/false?

Solution

Both the options are true.

The order is

select ...

from....

where...

group by....

having....

Hence according to this both the above written statements are true.