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 :