Question

Consider the following code example:

Answer 1

Answer:

This exercise includes the following question and options:

What is the logical error in the coded query?

A) The condition in the WHERE clause should be coded in the HAVING clause.

B) The column name for the fifth column in the result set doesn't match the data.

C) The three columns in the ORDER BY clause should use the DESC keyword so the city totals will be in the right sequence.

D) The condition in the HAVING clause should be coded in the WHERE clause.

And from the options provided, the error is in the 5th column, due to the column name in that result series/group doesn't really coincide with the data, thereby the correct option is B).