Show that a query using the HAVING clause has an equivalent formulation without a HAVING clause.

What will be an ideal response?

Hint: Allow the students to show that the restricted groups could have been restricted earlier with
a WHERE clause.

Computer Science & Information Technology

You might also like to view...

How do you know if a placeholder is selected?

A) the dotted line flashes B) the dotted line changes to a solid line C) the surrounding border changes to red D) the border changes to a bolded, red line

Computer Science & Information Technology

Which of the following is NOT a descriptive statistical function?

A) DAVERAGE B) STDEV.P C) FREQUENCY D) VAR.S

Computer Science & Information Technology