GIVE SQL COMMANDS

BRANCH

bid	bname
B01	Olympia
B02	Seattle

DEPARTMENTS

Did	Dname	bid
D1	Engineering	B01
D2	Security	B02
D4	Marketing	B01

EMPLOYEES

eid	Ename	City	Salary	did	mid
E1	Bill Gates	Redmond	90	D1	null
E2	Steve Jobs	Palo Alto	80	D2	null
E3	Ted Codd	New York	70	D2	E2
E4	Michael Stonebreaker	Berkeley	60	D2	E3
E5	Alan Kay	Palo Alto	60	D1	E1
E6	Adelle Goldberg	San Jose	60	D2	D2

9) All possible combinations of the name of employees with the departments without relating the employees to the departments

SELECT ______, ______ FROM _______, ________ ;

10) Name of Employees who work in Olympia branch

SELECT ____ename____ FROM _________, ___________, ________, WHERE _______, _________, __________;

13) The Department name and the sum of salary of all employees in the respective department.

14) Sum of Salary of All Employees

15) Sum of Salary by Department

16) Give a 10% raise to all Employees

17) Remove all employees located in Palo Alto