Question: Please use SQL LANGUAGE, show a screen shot for your answer In your workbench. thank you. 1) Display all invoices with balance due $200 or

 Please use SQL LANGUAGE, show a screen shot for your answer

Please use SQL LANGUAGE, show a screen shot for your answer In your workbench. thank you.

1) Display all invoices with balance due $200 or more and the invoice total is larger than $500. Return invoice number, date of invoice, and amount due. Sort by balance due in descending order. 2) Select all the vendors in the vendors table where the first initial of the vendor's first name matches the first initial of the last name of that vendor. Return 3 columns that include first and last names, and the city. Order the results in ascending order of the vendor's first name. 3) List all the invoices from Federal Express Corporation. Sort by invoice_number in ascending order. Create proper aliases for column headings to show result table as follows. 4) Insert a new invoice record into the invoices table. Choose relevant values for the fields. 5) Delete the invoice inserted in Problem 4. You can use the values you have chosen in Problem 4 to locate the record. 6) List the vendors who have a zip code that is common with at least another vendor. Create proper aliases for column headings to return the vendor's name and zip code. Sort the result table in ascending order of vendor zip code and make sure there are no duplicate rows. 7) Find the top 5 line items with the largest line_item_amount that belongs to vendor "Federal Express Corporation". Return the vendor name, invoice number and line_item_amount of these 5 items

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!