Code an SQL statement that will create the Customers table from the previous page. Remember that the table has a primary key and include the statements need to load the indicated records into the table.

Create an SQL statement that returns all of the data in the Customers table.

Create an SQL statement that will return the CustomerID and Address data for all records in the Customers table.

Create an SQL statement that will return the Address, City, and State information for Sally Withers

Create an SQL statement that will change the Sally Withers record in the Customers table so her last name is now Smith.

Create an SQL statement that will delete the John Mays record from the Customers table.

Customers Table CustomerlD FirstName LastName Address City State Repeat Mays 1001 1002 1003 John Sally Michael Brake 100 Walker StOmaha NE True Withers 2029 N. 104 St. Omaha NE rue 1123 S. 13th St. Omaha NE False Purchases Table ShipRecord OrderNoCustomerlD ProductNo Number Date 010316001 1001 010316001 1001 010316002 1002 010416001 1003 18023 13312 18023 17709 1/3/2015 1/3/2016 1/3/2016 1/4/2016