Question: Create a query that creates a new table called big_spenders. The new table will only have one field vendor name and will include only vendors
Create a query that creates a new table called big_spenders. The new table will only have one field vendor name and will include only vendors that have invoices with an invoice total greater than $1000. Finally, each big spending vendor's name should appear only once in the new table. Update the invoices so that the invoice date for all invoices is increased by 1 year. Please write the code out for sql workbench.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
