$27.$ Write a query to display the eight departments in the LGDEPARTMENT table sorted by department name.

$28.$ Write a query to display the SKU $($stock keeping unit$),$ description, type, base, cat egory, and price for all products that have a PROD$\_$BASE of Water and a PROD$\_$ CATEGORY of Sealer $($Figure P$7\mathrm{.}28).$

$29.$ Write a query to display the first name, last name, and email address of employees hired from January $1,2005,$ to December $31,2014.$ Sort the output by last name and then by first name $($Figure P$7\mathrm{.}29)$

$30.$ Write a query to display the first name, last name, phone number, title, and depart ment number of employees who work in department $300$ or have the title $$CLERK I.$$ Sort the output by last name and then by first name $($Figure P$7\mathrm{.}30)$