SQL Assignment 1 Copy your queries and paste it under each question. Upload the file to the Canvas submission folder. Using Teradata Viewpoint Database: db_pvfc11_big 8. For employees who live in TN or FL, list the age at which they were hired. (Hint: age hired can be computed using Employee Date Hired - Employee Birth Date) 9. Display the territory ID and the number of sales persons in the territory for all territories that have more than one sales person. Label the number of salespersons as NumSalespersons. 10. List MaterialName, Material, and Width for raw materials that are not cherry or oak and whose width is greater than 10 inches. CustomerShipAddress Customer_T DoesBusinessIn_T Employee Skills_T Employee_T OrderLine T Order_T PaymentType_T Payment_T Producedin T ProductLine_T Product_T Raw Material_T Salesperson_T Shipped_T Skill_T Supplies_T Territory_T Uses_T Vendor_T WorkCenter_T WorksIn_T