Please help me answer A,B,C. they all need to ha RA, TRC, and DRC solutions for each

1. (40 points) Consider the following schema: WORKERS(Wssn: int, wname: string, bdate: date, address: string) WORKON(ssn: int, cno: int, salary: int) COMPANY(cnumber: int, cname: string, location: string) MANAGER(mssn: int, mname: string, age: int) Note that every company is located at a specific type of location (Chicago, West Lafayette, etc.) and cno is referring to the cnumber in company. Write the following queries in RA, TRC, and DRC. The key fields are underlined. A. (10 points) Retrieve the sons of workers who work at Chicago. B. (10 points) Retrieve the managers' names who work at company number 10 and has an age greater than 30. C. (20 points) Retrieve the name and salary of workers who are not managers