Using SQL,
Subqueries in search conditions (within the where Clause)

1) Business case: the accounting

department would like a report of all invoice in the database that are larger than zylka design's largest invoice. Sprcifically the company, invoice data , number and total.
write a select statement that returns 4 columns: VendorName, InvoiceDate, InvoiceNumber and InvoiceTotal. Filter the results to only return records where the InvoiceTotal is more than the result(s) of the subquery.

Subquery Portion:

select the largest InvoiceTotal and filter the result to only return record(s) where VendorID is equal to 121.

Sort the result by VendorName and InvoiceTotal from largest to smallest.