This Critical Thinking Assignment requires you to use the SQL Server instance named SQLSERVERCSU and the HandsOnOne database and tables that you created in Modules 1 and 3, respectively. The objective of this activity is to hone your skills at manipulating data using SQL DML statements. Use Query Editor throughout this exercise.

Construct and execute INSERT statements to add the sample data in the following tables to the Customer and Address tables in the HandsOnOne database:

Additional Sample Data for Customer Table

CustomerID	CustomerName	CustomerAddressID
1	Western Supply Co.	2
2	Jake Harper	4
3	Elizabeth Harper	1
4	Abacus Consulting	3

Additional Sample Data for the Address Table

AddressID	Street	City	State	Zip Code
1	2400 Broadway	New York	NY	11201
2	320 21st Street	Atlanta	GA	30322
3	439 Skyline Blvd	Seattle	WA	98101
4	56 Park Avenue	Dallas	TX	75201

Construct and execute a query to list all customers with their corresponding cities and states. The list should be sorted in ascending numerical order by ZIP code, followed by customer name alphabetically. Take a screenshot of the Query Editor after you have executed this SQL command to show that it was completed successfully.

Construct and execute a SQL query to count the number of customers in each state. The list should be ordered by the number of customers in descending order, then by state code in ascending order. Take a screenshot of the Query Editor after you have executed this SQL command to show that it was completed successfully.

Construct and execute a SQL query to list the full names of all customers who have Harper in their name. Take a screenshot of the Query Editor after you have executed this SQL command to show that it was completed successfully.