c) Consider the following relations:
lives (person_name, street, city)
works (person_name, company_name, salary)
located (company_name, city)
manages (person_name, manager_name)
Answer the following using SQL:
i) Find the names of persons working in "Propel" company, earning Rs. 50000.
ii) Get the number of companies in each city.
iii) Ram's manager has changed and the new manager is Naren. Make changes accordingly.
iv) Sunil doesn't work anymore. Reflect this change in the database.
v) Create a view named "ChennTeam" that contains details of all persons who work in Chennai, in ascending order of person_name