Question: Create a view called overdue_accounts that lists invoices with a past due balance. For this question we will pretend today's date is 2014-09-10 and we

 Create a view called overdue_accounts that lists invoices with a past

Create a view called overdue_accounts that lists invoices with a past due balance. For this question we will pretend today's date is 2014-09-10 and we are checking which invoices are outstanding. Include the following columns: the vendor's name the invoice due date the terms due days the number of days from invoicing to 2014-09-10 the number of days that the invoice is overdue the total balance due for the invoice Use aliases to provide neat, descriptive, user-friendly column names. Sort the results in descending order by overdue days and alphabetically by vendor. If your dates in invoices are not in 2014 then please run the script database creation script linked on assignment 4. HINT: test your view using a statement such as: SELECT * FROM overdue_accounts

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 Accounting Questions!