contestada

Consider the following code example:

SELECT VendorState, VendorCity, VendorName, COUNT (*) AS InvoiceQty,
SUM( InvoiceTotal) AS InvoiceAVg

FROM Invoices JOIN Vendors
ON INvoices.VendorID= Vendors.VendorID

WHERE VendorState < 'e'
GROUP By VendorState, VendorCity, VendorName
Having SUM (InvoiceTotal)>500
ORDER By VendorState, VendorCity, VendorName;

Respuesta :

mbm1000

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).

Otras preguntas