subject

Querying Databases (70 Points) 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. 1.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
2.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.
3.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.
4.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.
5.Your final step in this assignment is to compose a one page report that outlines your experience completing this assignment. Which task was the most difficult for you? Which was the easiest? Your repost should follow CSU-Global Guide to Writing and APA Requirements. After you have completed this Critical Thinking Assignment, submit one MS Word document that contains the three screenshots and the written report. Insert all of the screenshots into the document, label each of them clearly, and include the 1 page report below the screenshots; then upload this single MS Word document in the assignment page.

ansver
Answers: 3

Another question on Computers and Technology

question
Computers and Technology, 22.06.2019 17:00
Your computer running windows 10 is doing some very strange things with the operating system. you are fairly certain it is not a hardware issue. you need to try to get further insight into what is going on within the operating system. which tool would be best suited for this?
Answers: 2
question
Computers and Technology, 22.06.2019 22:30
Which of the following factors would your hypothetical supervisor look at when deciding whether to test a biological material sample for dna? the amount of other evidence you have implicating a suspect in a crime the annual budget for the crime lab both of the above none of the above; you would almost always order a test
Answers: 3
question
Computers and Technology, 23.06.2019 23:30
A. in packet tracer, only the server-pt device can act as a server. desktop or laptop pcs cannot act as a server. based on your studies so far, explain the client-server model.
Answers: 2
question
Computers and Technology, 24.06.2019 17:50
Acontact list is a place where you can store a specific contact with other associated information such as a phone number, email address, birthday, etc. write a program that first takes in word pairs that consist of a name and a phone number (both strings). that list is followed by a name, and your program should output that name's phone number.
Answers: 1
You know the right answer?
Querying Databases (70 Points) This Critical Thinking Assignment requires you to use the SQL Server...
Questions
question
Social Studies, 05.10.2020 14:01
question
History, 05.10.2020 14:01
question
Mathematics, 05.10.2020 14:01
question
Mathematics, 05.10.2020 14:01
question
History, 05.10.2020 14:01
question
Spanish, 05.10.2020 14:01
Questions on the website: 13722367