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

21PrincipeMichelle963-
4561ApexSouthPaidN94000853007/2/1974
23MavisJohn147-
4561SujourEastUnpaidY25000266003/5/1989
*Overdue Status indicates customers with a balance that is 30
or more days overdue
Part 1: Build your SELECT statement by choosing the certain
clauses from the list below and putting the clauses in the
correct order:
SELECT City, Count(*)
ORDER BY 2
WHERE Count(*) > 1
SELECT Region, Count(*)
GROUP BY City
FROM tblCustomer
ORDER BY Count(*)
HAVING Count(*) > 1
GROUP BY Region
ORDER BY 2 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.