Write a SELECT statement that answers this question: Which invoices have a PaymentTotal that's greater than the median PaymentTotal for all paid invoices? (The median marks the midpoint in a set of values; an equal number of values lie above and below it.) Return the InvoiceNumber and InvoiceTotal for each invoice. Hint: Begin with the solution to exercise 2, then use the ALL keyword in the WHERE clause and code "TOP 50 PERCENT PaymentTotal" in the subquery.

Here is the SELECT statement:

SELECT InvoiceNumber, InvoiceTotal  

FROM INVOICES

WHERE PaymentTotal > ALL

(SELECT TOP 50 PERCENT PaymentTotal  

FROM INVOICES

ORDER BY PaymentTotal)

Explanation:

This can also be written as:

SELECT InvoiceNumber, InvoiceTotal  

FROM INVOICES

WHERE PaymentTotal >

(SELECT AVG(PaymentTotal )

FROM invoices

WHERE PaymentTotal > ALL

(SELECT TOP 50 PERCENT PaymentTotal  

FROM INVOICES

ORDER BY PaymentTotal)

solution:

the auto-correct option of the auto-correct tool enables you to add and delete words that do not follow abbreviation rules because:

it is a feature that allows outlook to correct common spelling and typing errors and to replace characters with symbols. we can also can use auto-correct as a shortcut, which means we can type a small string of characters and have those characters replaced by a longer string.