Documenti do 19620Shop%20HW.pdf Homework Chapter 3 Chapter 3 My Guitar Shop weg Chapter 3 How to retrieve data from a single table Exercises Enter and run your own SELECT statements In these exercises, you'll enter and run your own SELECT statements. 1. Write a SELECT statement that returns four columns from the Products tables product code, product name, list price, and discount percent. Then, run this statement to make sure it works correctly. Add an ORDER BY clause to this statement that sorts the result set by list price in descending sequence. Then, run this statement again to make sure it works correctly. This is a good way to build and test a statement, one clause at a time. 2. Write a SELECT statement that returns one column from the Customers table named full name that joins the last name and first_name columns. Format this column with the last name, a comma, a space, and the first name like this: Doo, John Sort the result sct by last name in ascending sequence. Return only the customers whose last name begins with letters from M to Z NOTE: When comparing strings of characters, 'M' comes before any string of characters that begins with 'M'. For example, "M' comes before 'Murach. Write a SELECT statement that returns these columns from the Products table: product_name The product_name column list price The list price column date added The date_added column Return only the rows with a list price that's greater than 500 and less than 2000 Sort the result set in descending sequence by the date added column