1. Using sub-query, produce a reports that include parts id, name, cost price and sales price for all parts that belong to part type Engine and supply by Bosch.

2. Write a query to Generate a report that shows the total sales price of all part types where the purchase order date is in the year 2019. Display the report you just created based on part type names with the sales price in ascending order.

Purchase Order (PONO, PODate, PartID, POQuantity) Supplier (SupplierID, SupplierName, SupplierAddress, SupplierEmail, SupplierPhoneNum) Parts (PartID, PartName, PartUnit, StockLevel, CostPrice, SalesPrice, Location, SupplierID, PartTypeID) PartType (PartTypeID, PartTypeName, PartTypeDescription) Customer (CustID, CustName, CustPhoneNum, CustEmail, CustAddress) CustomerOrders (OrderID, CustID, Order Date, PartID)