Top $O^{\text{'}}$ the Morning $($TOM$)$ is a company that provides custom stone countertops for kitchens, bathrooms, and other areas of a home or business. The company is providing you access to sample data for a small area of their overall database. Read the brief description below to help you understand the data. The data were captured in $2024.$

TOM ERD

Explanation of the data model:

The EMPLOYEE table contains a portion of the data kept on employees that work for TOM doing installation of purchased products. The employees are organized into crews each day that they work. A crew is typically comprised of a leader and one or more assistants. The leader is responsible for the quality of the installation work done by the crew that day. Employees are not always part of the same crew $-$ crews change from day to day. The TRUCK table contains some of the data about the box trucks that crews use to deliver products to the installation site. The stone countertops are very heavy $($usually $300-400lbs$ each$)$ so care must be taken to ensure the weight capacity of the trucks is not exceeded. Each day a truck can be assigned to deliver multiple products and the group of employees that are in a crew that day. The truck usually has multiple products loaded each assigned day. The products may be destined for one job site or multiple job sites. The crew drives the truckload of products to the site and installs the products that were ordered for that job site. Each product is a stone countertop. The product has a description to help the crew distinguish between the products on their truck. The weight of the product and how many minutes the crew is estimated to need to install the product is also recorded. There is also a description of the installation location for each product so the crew can be assured of putting each product in the correct location within the building. The SITE table has data about the job sites where products are to be installed, and who to contact about any issues with accessing the site,

Page $2$ of $8$

Among the factors that impact Installation time are the weight of the product and the complexity of the sink alignment. TOM is interested in improving installation estimates. Write a query to display the product number, product description, installation minutes, installation minutes per pound of the product, the contact person for the site where the product is installed, the contact phone number, the date it was installed, and the employee that was the leader of the crew installing the product. Include products that have not been delivered and installed yet. Limit the results to:

Kitchen products with a $2-$hole sink with installation time above $70$ minutes

Any product with a $3-$hole sink with installation time below $70$ minutes.

Sort the results by minutes per pound in descending order, then by product number in ascending order.

Result $(6$ rows$)$:

$\backslash$table$[[$PROD$\_$NUM,PROD$\_$DESCRIPT,PROD$\_$INSTALL$\_$MINUTES,MINUTES $/$ POUND,SITE$\_$CONTACT,SITE$\_$PHONE,ASSIGN$\_$DATE,CREW LEAD$],[121,$Kitchen island with $2$ hole sink,$80,0\mathrm{.}1930000,$Ed Walker,$283-555-2021,2024-08-06,$Dianne Hermann$],[123,$Kitchen Cabinet top $3-$hole sink and $2$ hole sink,$85,0\mathrm{.}1760000,$Bria Rowden,$283-555-8553,$NULL,$],[101,$Kitchen Cabinet top with $2$ hole sink,$75,0\mathrm{.}1720000,$Raquel Aviel,$283-555-7755,2024-08-05,$Sam Jones$],[120,$Kitchen top for $2$ hole sink,$75,0\mathrm{.}1690000,$Ed Walker,$283-555-2021,2024-08-06,$Dianne Hermann$],[125,3$ hole sink bathroom vanity top,$60,0\mathrm{.}1690000,$Russ Smith,$283-555-5453,$NULL,$],[104,$Kitchen Cabine: top with $3$hole sink,$65,0\mathrm{.}1630000,$Jameison Jones,$283-555-5029,2024-08-05,$Sam Jones$]]$

Write a SQL query to answer Q $5$