a) Write create table statements for the following schema. (5 marks) b) Insert: (5 marks) • 2 banks, • 2 branches for each bank • 5 employees and 1 manger for each branch. In each branch at least one employee must be older than the manager) • 2 accounts related to two employees of each branch (4 accounts in total, one local, one overseas) • 1 local account related to all employees without any account except one. (In each branch, there should be one employee without any associated account) • 3 transactions for each account. (Except: one account in each branch should not have any transaction associated with it) c) Write the following sql queries: (10 marks) • Find how many accounts each branch has. • Find the name of the oldest employee of each branch. • Find sum of all the local transactions for each branch. • Find name of employees who do not have any customer (no account). • Find which branch is older than the other branch that is the sum of the ages of all employees of the branch is more than the sum of the ages of all employees of the other branches. • Find how many employees are older than any of the two managers in each branch. • For each bank the bank with most overseas transactions. • Find all accounts with any transaction. Report their bank, branch, and account. • Find branches that have two employees with two employees born in the same year. • Find branches that have an employee with two letter ‘a’ and ‘c’ in their last names. Show the branches and employee last name.