Expert Answers /
(Solved): ..:: + 2:03: Optional DuL and LIVL assignment - Word Layout References Mailings Review Vi ...
..:: + 2:03: Optional DuL and LIVL assignment - Word Layout References Mailings Review View Acrobat Tell me what you want to do... Colors Fonts Document Formatting Optional DDL and DML assignment Write DDL query to CREATE these two tables in your schema. bank employee INT bank employee id PRIMARY KEY AUTO_INCREMENT bank employee Dame VARCHAR(100) NOT NULL bank emloye..supervisor id INT DEFAULT NULL bank employee salary. INT NOT NULL bank emloyee, supervisorid reference bank employee (bank employee id) bank_branch INT braach.id PRIMARY KEY AUTO_INCREMENT branch manager, id DEFAULT NULL branch city VARCHAR(S) NOT NULL bank, manager id reference bank employee (bank employee_id) Document Formatting Write DML query to INSERT following data in bank employee table. bark employee id bank employee supervisor id bark employee rame Jean Grey Carol Darivers Stephen Strange Thor Charles Xavier Wanda Macmoff Erik Magnus Bruce Banner Logan Wade Wilson Thala Steve Rogers Tony Stark Peter Parker bank employee salary 200000 180000 175000 180000 160000 160000 150000 200000 160000 160000 150000 160000 190000 150000 -NON Write DML query to INSERT following data in bank branch table. branch id branch manager_jd branch oty Camden Clementon Bladewood Sewell Glassboro Turnersville Deptford Atlantic Oy Ocean Oy Smithvile Vorhees Write DML SELECT query to find bank employee.id, bank employee name of employees who do not have a supervisor assigned. Write DML SELECT query to find bank employee id, bank employee.name bank employee supervisorid of employees who are supervised by bank employee supervisor id = 2. Write DML SELECT query to find bank employee.id, bank employee.name of employees who earn more than 180,000. Write DML SELECT query to find bank employee.id, bank employee name bank.cmployee supervisorid and employee supervisor name of each employee. Write DML SELECT query to find bank employee name of all employee who are supervisors. Write DML SELECT query to find bank.emlovee.id, bank employee..bame, bank.employee...salary of ALL employees who are earning MAX salary. Write DML. SELECT query to find branch id branch city, bank.managerid and bank manager name of all branches WHERE bank manager id IS NOT NULL. Write DML SELECT query to find bank manager name(s) of all employees who manage bank branches IN Sewell or Glassboro. Write DML SELECT query to find bank manager names, branch count of all employees who manage more than one branch. Write DML SELECT query to find bank employee.id, bank employee..came bank employee salary of all employees who earn more than their supervisor.