For the following given database, write SQL queries:-

employee(al employee_name, street, city)

works(eid, ad, salary)

company(cla, company name,city)

Manager(dcl, manager_name)

(i)Find the names, street and city of all employees who work for "AZT" and earn more than Rs. 30,000

(ii) Find the narnes of all employees having "K" as the first letter in their names

(iii) Display the annual salary of all employees.

Mumbai University > Computer Engineering > Sem 4 > Database Management System

Marks: 10 M

Year: Dec 2015

i. Find the names, street and city of all employees who work for "AZT" and earn more than Rs. 30,000

SELECTemployee_name,street,city
FROM employee e ,works w
WHERE e.eid=w.eid
AND salary>30000 
AND w.cid in 
(SELECTcidFROM companyc WHEREcompany_name=”AZT”)

ii. Find the narnes of all employees having "K" as the first letter in …