Consider the employee database of Figure 3.19, where the primary keys areunderlined. Give an expression in SQL for each of the following queries.a. Find ID and name of each employee who lives in the same city as thelocation of the company for which the employee works.b. Find ID and name of each employee who lives in the same city and on thesame street as does her or his manager.c. Find ID and name of each employee who earns more than the averagesalary of all employees of her or his company.d. Find the company that has the smallest payroll.

Consider the given bank database. Compose SQL Queries for each of below scenarios. branch(branch_name,branch_city,assets) customer(customer_name,customer_address,customer_city) loan(loan_number,branch_name,amount) borrower(customer_name,loan_number) account(account_number,branch_number,balance) depositer(customer_name,account_number) a. Find the names of all branches located in “Chicago”. b. Find the names of all borrowers who have a loan in branch “Downtown”. c. Find all loan numbers with a loan value greater than $10,000. d. Find the names of all depositors who have an account with a value greater than $6,000.

Consider the library database of Figure 3.20.Write the following queries in SQL.a. Find the member number and name of each member who has borrowedat least one book published by “McGraw-Hill”.b. Find the member number and name of each member who has borrowedevery book published by “McGraw-Hill”.c. For each publisher, find the member number and name of each memberwho has borrowed more than five books of that publisher.d. Find the average number of books borrowed per member. Take into accountthat if a member does not borrow any books, then that member doesnot appear in the borrowed relation at all, but that member still counts inthe average.