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

 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

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. 8) Select all vendors who have not submitted an invoice. Return a result table that contains the vendor's name and city. Sort by vendor name in descending order. 9) List the vendors and how many invoices that belong to each vendor in descending order. Use proper aliases and return results as below: 10) List all the invoices where the invoice_total is less than the average invoice_total of all invoices. Order by invoice_total in descending order and only return rows where the invoice_total is larger than 800

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!