Question: Task 8 . Using T - SQL , drop all nine tables and the two schemas. Do not forget to copy and paste these commands
Task Using TSQL drop all nine tables and the two schemas. Do not forget to copy and paste these commands right after Task Task Using TSQL retrieve the following data using the SELECT statement. Query 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 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 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 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
