SQL Query Workbench Questions:

The above screenshot represents a database called Database Model.

The database has 7 tables. Attached is a screenshot of all tables and columns in each table. Please write SQL querry to get the following:

1. Provide a list of all employees of CMC. The following information is required: Employee Last Name, Employee First Name, Office Address, Territory, Supervisor Last Name,Supervisor First Name.

2.Provide a list of all Product Lines of CMC along with their minimum, maximum and average Buy Price.

3.Provide a list of all Orders that have Order Amount greater the $60,000. Provide Order Number, Order Date, Customer Name and Order Amount. Sort the list by largest Order Amount first.

4.Provide a list of all Product Lines sold in year 2004 along with their Buy Price, Sold Price and Profit for each Product Line.

5.CMC wants to reward their Sales Representatives and needs a list of all Sales Representatives (Last Name, First Name) along with Product Line and total amount of the Product Line sold in 2004 by each Sales Representative.

Q Filter objects Triggers orders employees payments Columns employeeNumber productlines )Columns E] offices [02] Columns employees lastName firstName OfficeCode productLine textDescription htm|Description Q Filter objects ( orderdeta extension phone addressLine1 addressne2 state g classicmodels email Tables [0] Columns image OfficeCode reportsTo jobTitle E customers b Columns 00 orderNumber orderDate Foreign Keys Triggers customerNumber customerName contactastName contactFirstName Indexes requiredDate postalCode products shippedDate status comments customerNumber Eh Foreign Keys territory columns Triggers productcode productName - office Foreign Keys Triggers phone [0] columns Indexes productLine OfficeCode productScale productVendor productDescripti quantitylnStock addressLine2 Foreign Keys Columns B. Triggers OrderNumber productCode quantityOrdered priceEach orderLineNumber nts addressLine1 addressne2 postalCode Columns country salesRepEmploy customerNumber * checkNumber MSRP creditLimit paymentDate amount indexes Foreign Keys postalCode territory Indexes Foreign Keys Triggers Foreign Keys Triggers Triggers Viese Indexes h Foreign Kevs