Examine the structure of the employees table.
You want to display the maximum and minimum salaries of employees hired 1 year ago.
Which two statements would get the correct output?
A.
Option A
B.
Option B
C.
Option C
D.
Option D
Explanation:
Incorrect:
Not B, not D: You cannot use a GROUP BY clause in a WHERE statement.
A + C is correct but the explanation given is wrong.
You CAN use a GROUP BY in a WHERE statement.
However you can not use a group function (max/min) in a group by clause.
https://stackoverflow.com/questions/42470849/why-are-aggregate-functions-not-allowed-in-where-clause/42471383