Task 11: Find the ID, first name, and last name of each customer whose first name begins with the letter S.

Task 12: List all details about all items. Order the output by description

Task 16: List the item ID, description, and on-hand value of each item whose number of units on hand is more than the average number of units on hand for all items.

Task 20: List the sum of the balances of all customers for each sales rep but restrict the output to those sales reps for which the sum is more than $150

11:221 !!! Q Q W 132 Module 4 11. . How do you sort data in descending order? 12. What are the SOL aggregate functions? 13. How do you avoid including duplicate values in a query's results? 14. What is a subquery? 15. How do you group data in an SQL query? 18. When grouping data in a query how do you restrict the output to arly those groups satisfy ing some condition? 17 How do you find rows in which a particular column contains a rull value? Critical Thinking 1. Use the Internet to research the SOL (charist) wildcard that is available in Oracle and SC Server. Using the information you find, curplate the following SOL Command to find all cit- ies that begin with the letters 'C' or 'G' SZLECT COSTOMER_NAME, CITY PRON CUSTOMER NEBRE CITY LIKE Be sure to cite the URL(5) that provided the information Case Exercises Kim Tay Pet Supplies Use SOL and the Kim Tay Pet Supplies calabase (see Figure 1-2 in Module 1) lo complete the following exercises. If directed to do so by your instructor, use the information provided with the Module 3 Exercises to print your output or save it to a document. 1 List the item ID description, and price for all items. 2. List al rows and columns for the complele INVOICES table. 3. List the first and last names of customers with credit limits af $1,000 or more 1. List the order number for each order placed by customer number 125 on 11/15/2021 (Hint If you need help use the discussion of the DATE data type in Figure 3-19 in Module 3.) 5. List the number and name of each customer represented by sales rep 10 or sales rep 15 6. List the item ID and description of each item that is not in categary HOR. 7 List the item ID. description, and number of units on hand for sach item that has batween 10 and 30 units on hand, including both 10 and 20. Provided two alternate SOL Statements to produce the same results. 1. List the item ID description, and on-hand value (units on hand unit price) at cach item in category CAT. (On-hand value is technically units on hand cost, but there is no COST column in the ITEM table.) Assign the name ON_HAND_VALUE to the computed column. Copyright 2020 Canpope Leaming. Nichts Reserved. May not be cock scored ad.pload in whole or in par. VICN 02200-203 Pope www. , { 132 of 337