Question: Task 8 . Using T - SQL , drop all nine tables and the two schemas. Do not forget to copy and paste these commands

Task 8. Using T-SQL, drop all nine tables and the two schemas. Do not forget to copy and paste these commands right after Task 3! Task 9. Using T-SQL, retrieve the following data using the SELECT statement. Query 1. Return the customers' names and locations. Sort the result in descending order for the location and then sort the sorted result by the first name in ascending order. Hint: You need to use ORDER BY Also, write your answer here: Query 2. Return the customers' names and retrieve the customer list sorted by the length of the first name. Hint: Use ORDER By and a function to do this task. Also, write your answer here: Query 3. Return all products from the products table and sort them by their list prices and names. You should skip the first three products and return the rest. Hint: You need to do the above query using a particular keyword in the ORDER BY clause. Also, write your answer here: Task 10. Does any of your queries require to be optimized for their performance? How do you apply performance optimization to your queries? Apply the performance optimization and capture the screen of your results in SSMS and add them below. Write your answer here:

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!