Use Ch$07$ LargeCo database to answer the following problems.

The Ch$07\_$LargeCo database stores data for a company that sells paint products. The company tracks the sale of products to customers.

The database keeps data on customers $($LGCUSTOMER$),$ sales $($LGINVOICE$),$ products $($LGPRODUCT$),$ which products are on which invoices $($LGLINE$),$ employees $($LGEMPLOYEE$),$ the salary history of each employee $($LGSALARY$\_$HISTORY$),$ departments $($LGDEPARTMENT$),$ prod$-$ uct brands $($LGBRAND$),$ vendors $($LGVENDOR$),$ and which vendors supply each product $($LGSUPPLIES$).$ Some of the tables contain only a few rows of data, while other tables are quite large; for example, there are only eight departments, but more than $3,300$ invoices containing over $11,000$ invoice lines.

Write your SQL statement in the Workbench, then click the Execute button to execute your statement..

Problem $27$

Write a query to display the eight departments in the LGDEPARTMENT table sorted by depart$-$ ment name.