Consider the following schema and answer the following SQL queries.
Employee ( person_name , street, city)
Works (person_name, company_name, salary) Company (company_name, city )
Manages (person_name , manager_name)
i) Find name and cities of residence of all employees who work for Wipro.
ii) Find the name of all employees in this database who live in the same city as the company for which they work.
iii) Find the name of all employees in this database who do not work for Wipro.
iv) Find the name street address and cities of all employees who work for Wipro and earn more than Rs. 10000
