Sams Teach Yourself SQL in 10 Minutes (Fifth Edition) includes challenges at the end of some lessons. Solutions to the challenges are presented here. Just keep in mind that there is rarely one solution to a SQL challenge, so if your solutions look different but produce the desired result, that’s ok.
Using INSERT and columns specified, add yourself to the Customers table.
-- Obviously replace the details with your own INSERT INTO Customers(cust_id, cust_name, cust_address, cust_city, cust_state, cust_zip, cust_country, cust_email) VALUES(1000000042, 'Ben''s Toys', '123 Main Street', 'Oak Park', 'MI', '48237', 'USA', 'email@example.com');
Make a backup copy of your Orders and OrderItems tables.
-- MySQL, MariaDB, Oracle, PostgreSQL, SQLite CREATE TABLE OrdersBackup AS SELECT * FROM Orders; CREATE TABLE OrderItemsBackup AS SELECT * FROM OrderItems; -- SQL Server SELECT * INTO OrdersBackup FROM Orders; SELECT * INTO OrderItemsBackup FROM OrderItems;