Problem #1

Display all columns from the Vendors table for those vendors that are located in California and do NOT have a value in the VendorPhone column. Order the results by VendorName in ascending order.

Problem #2

Display the VendorID, VendorName, and the contact name (show the contact name as the VendorContactLName concatenated to the vendorcontactFName separated by a comma.). Only show those vendors that have the word printing somewhere in the VendorName. Order the results by VendorContactLName in ascending order and then VendorContactFName in ascending order.

Problem #3

Display VendorNames from the Vendors table and any associated InvoiceIDs from the Invoices table. Show VendorNames even if they do not have any associated invoices. Order the results by VendorName in ascending order.

Problem #4

Display InvoiceIDs from the Invoices table and the sum of the associated InvoiceLineItemAmountss from the InvoiceLineItems table. Only show those invoices where the sum of InvoiceLineItemAmounts is more than $10,000. Order the results in descending order by the sum of the InvoiceLineItemAmounts.

Problem #5

Display the InvoiceID from the Invoices table that has the highest InvoiceTotal using a subquery. Thank you.