SQL practice: INSERT, UPDATE, DELETE

Insert a product called 'Test Panel', category 'Accessory', price 1000, cost 800, no thickness.

Change its price to 1200.

Change its price and cost together — price to 1300, cost to 900.

Delete it again.

Insert two new customers in one statement.

Write the SELECT you would run before an UPDATE that raises all Adhesive prices by 5%.

Now write that UPDATE.

Delete the two customers you inserted in 27-5.

Explain what DELETE FROM orders; would do, and why it would probably fail anyway.

Use TRUNCATE TABLE to empty all rows from the staging table staging_leads.