Answered step by step
Verified Expert Solution
Question
1 Approved Answer
SQL BRANCH bid B01 B02 EMPLOYEES bname Olympia Seattle eid Ename E1 Bill Gates E2Steve Jobs E3 Ted Codd E4 Michael Salary did mid City
SQL
BRANCH bid B01 B02 EMPLOYEES bname Olympia Seattle eid Ename E1 Bill Gates E2Steve Jobs E3 Ted Codd E4 Michael Salary did mid City Redmond 90 Palo Alto80 New York70 Berkeley 60 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 Jose 60 D1 E1 D2 D2 Goldber 9) All possible combinations of the name of employees with the departments without relating the employees to the departments (2 points). SELECT 10) Name of Employees who work in Olympia branch (6 points) SELECT FROM FROM WHEREStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started