Using Insert Into what SQL query can be used to insert new rows into the Terms table
Question:
Using Insert Into what SQL query can be used to insert new rows into the "Terms" table for 120 and 180 day terms?
2. Using Select Into and Update (with a Subquery) what SQL query can be used to make a new table called "InvoiceCopy" that contains all the data from the "Invoices" table? After creating the new table, what SQL query can be used to update the Terms ("TermsID" column) to the newly created 120 Day term for all Vendors in 'CA' and 'NV'?
3. Using Delete what SQL query can be used to delete rows from the "InvoiceCopy" table where the Invoice Total is less than $200?
4. Using Delete (with a Subquery) what SQL query can be used to delete rows from the "Invoices_Paid" table where the Vendor is based in Michigan ('MI')?
Concepts of Database Management
ISBN: 978-1285427102
8th edition
Authors: Philip J. Pratt, Mary Z. Last