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$),$ product 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. Use your local MySQL WORKBENCH ONLY