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

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!