Question: Write a SELECT statement that returns these columns from the invoices table: the invoice_number column, the invoice_date column, the invoice_date column plus 30 days, the
Write a SELECT statement that returns these columns from the invoices table: the invoice_number column, the invoice_date column, the invoice_date column plus 30 days, the payment_date column, a column named days_to_pay that shows the number of days between the invoice date and the payment date. The number of the invoice date's month. The four-digit year of the invoice date. When you have this this working, add a WHERE clause that retrieves just the invoices for the month of May based on the invoice date, not the number of the invoice month.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
