Write a Recursive Query using Buyer Table 10. Write an SQL statement to return Supervisor Superviso

Write a Recursive Query using Buyer Table 10. Write an SQL statement to return Supervisor, Supervisor Position, Buyer, Buyer Position where the Buyer Position is ‘Buyer l' 11. Write an SQL statement to return Supervisor, Supervisor Position, Buyer, Buxes Position and the Count of Buyer Position(*Use Group By) Right vs. Left Outer Join 12. Write an SQL statement to return all records from warehouse table right outer joining the inventory table. 13. Write an SQL statement to return all records from warehouse table left outer joining the inventory table. Union vs. Union All 14. Write an SQL statement to return all products from all the catalog tables for the three years (2016, 2017 & 2018). 15. Write an SQL statement to return unique products from all the catalog tables for the three years (2016. 2017 & 2018). Intersect vs. Except 16. Write an SQL statement to return what products were available for sale (by either catalog or Web site) in both 2017 and 2018. 17. Write an SQL statement to return what products were available for sale (by either catalog or Web site) in 2017 but not in 2018.