SQL - Microsoft SQL Server

BRANCH bid B01 B02 EMPLOYEES bname Olympia Seattle City Redmond 90 Palo Alto 80 New York 70 Berkeley60 Salary did mid eidEname E1 Bill Gates E2Steve Jobs E3 Ted Codd E4 Michael D1 null D2 null D2 E2 D2 | E3 DEPARTMENTS Did D1 D2 D4 Dname Engineering Security Marketing bid B01 B02 B01 Stonebreaker E5 Alan Kay E6 Adelle Palo Alto 60 San Jose60 D1 E1 D2 D2 Goldber For 1-8, match question on the left with SQL code on the right (2 points each) 1) Departments (whole row) 2 Name and the city of all employees 3) Employees located in Palo Alto (whole row) 4) name of all Employees w/salary greater than 75000 5) name of the employee that has the biggest salary 6) name of the employees & corresponding department WHERE Salary (SELECT MAX(Salary) FROM Employees); b) SELECT ename, city FROM Employees; c) SELECT FROM Employees WHERE city- 'Palo Alto'; d) SELECTFROM Departments; e) SELECT ename FROM Employees WHERE Salary > 75000; name f) SELECT ename, dname FROM Employees e, DEPARTMENTS d WHERE d.did - e.did; g) SELECT e1.ename, e2.ename FROM Employees e1, Employees e2 WHERE e1.mid-e2.eid; 7) name of Employees and the Corresponding Manager Names 8) Employees that do not work in Security Department h) SELECT ename FROM Employees WHERE did NOT in (SELECT did FROM Departments WHERE Dname- 'Security' ); a) SELECT ename FROM Employees For 9-10, fill in the blanks