BIS 345 MENTOR Great Stories Here/bis345mentor.com BIS 345 MENTOR Great Stories Here/bis345mentor.com | Page 20

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:
Part 2: Describe at least two features you would include that would add
functionality to the report and improve its flexibility for the user. (Points :
25)
Part 2: If I had to include two features to add functionality to the report
and improve its flexibility they would be:
==================================================
BIS 345 Quiz 1
FOR MORE CLASSES VISIT
www.bis345mentor.com
1. (TCO 2) Use the ____ data type for columns that contain letters and
special characters and for columns containing numbers that will not be
used in calculations