Write SQL commands for the following tables. Employee (ename, street, city) Works (ename, cname, salary, joindate) Company (cname, city) Manages…

Write SQL commands for the following tables.

• Employee (ename, street, city)
• Works (ename, cname, salary, joindate)
• Company (cname, city)
• Manages (ename, mname)

(a) Find the name, street and city of employees who work for First Corporation Bank and earn more than 30000.

(b) Find the names of all employees who live in the same city as the company for which they work.

(c) Give all employees of First Century Bank a 10 percent salary raise.

(d) Find the company with a payroll of less than 100000.