Question: 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

 7) Find the top 5 line items with the largest line_item_amount

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!