Part 3: What function did you use to extract the three-digit exchange? Why did you select this function? Rewrite the SQL using a different function to extract these characters.( Points: 25) Part 3: To extract the three-digit exchange I used the LEFT( Phone, 3) funcion.
37.( TCO 3) Refer to the tblCustomer table below. As a data analyst, you have been requested to select rows that meet the following requirements. For each city, list the name of the city, and the number of customers in that city. Include only those cities that have more than 1 customer in them. Order the data by city in descending order. tblCustomer:
Part 1: SELECT City, COUNT(*) FROM tblCustomer GROUP BY City HAVING COUNT(*)> 1 ORDER BY City DESC; Part 2: Did you select any filter clause( s)?( WHERE, HAVING) Justify your choice of filter( s).( Points: 25)
38.( TCO 6) Evaluate the Supplier List report below. Management requested this report so they can monitor the value and quantity of the stock on hand; a requirement of the report is to be able to match the product to the supplier.
Part 1: Describe at least two enhancements that would make this report more readable to the user. Part 1: The two enhancements I would make would be: