Explanation:
Logical functions provide decision-making tools for information in a spreadsheet. They allow you to look at the contents of a cell, or to perform a calculation, and then test that result against a required figure or value.
Correct Answer:
c.
SELECT InvoiceNumber, VendorName
FROM Invoices JOIN Vendors ON Invoices.VendorID = Vendors.VendorID
WHERE InvoiceTotal IN (SELECT MAX(InvoiceTotal) FROM Invoices)
Explanation:
All options only differ on the WHERE clause:
a: WHERE InvoiceTotal = MAX(InvoiceTotal)
Fails because aggregate functions (like MAX, COUNT, etc) have to be used on the SELECT clause.
b: WHERE InvoiceTotal = (SELECT MAX(InvoiceTotal))
Fails because the SELECT clause is incomplete.
c: WHERE InvoiceTotal IN (SELECT MAX(InvoiceTotal) FROM Invoices)
This one is correct, and returns the InvoiceNumber and VendorName register with the largest value on the InvoiceTotal field.
Answer:
example in ( 4,6,9,3,7) lowest value is 3and highest is 9.
The mouse down block C, 2) is c, and
Buying something you need not want is a good spending habbit :)
