Consider the following relations with key underlined
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 and city of persons who work for manager John.
(ii) Find the names of persons who live in the same city as the company they work for.
(iii) John's manager has changed. The new manager is Anna.
(iv) Susan doesn't work anymore.
(v) Create a view BangWork (person_name, company_name, manager_name) of all people who work in Bangalore in ascending order of person name.