Question: please solve it through SQL Language and show a screenshot for your work on your computer. Thank you 5. Modify the solution to exercise 4

 please solve it through SQL Language and show a screenshot for

please solve it through SQL Language and show a screenshot for your work on your computer. Thank you

5. Modify the solution to exercise 4 so it returns only invoices dated in the second quarter of 2014 (April 1, 2014 to June 30, 2014). This should still return 10 rows but with some different line item counts for each vendor. Hint: Join to the Invoices table to code a search condition based on invoice_date. 6. Write a SELECT statement that answers this question: What is the total amount invoiced for each general ledger account number? Return these columns: The account number from the Invoice_Line_Items table The sum of the line item amounts from the Invoice_Line_Items table Use the WITH ROLLUP operator to include a row that gives the grand total. This should return 22 rows. Note: Once you add the WITH ROLLUP operator, you may need to use MySQL Workbench's Execute SQL Script button instead of its Execute Current Statement button to execute this statement. 7. Write a SELECT statement that answers this question: Which vendors are being paid from more than one account? Return these columns: The vendor name from the Vendors table The count of distinct general ledger accounts that apply to that vendor's invoices This should return 2 rows

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!