Answered step by step
Verified Expert Solution
Question
1 Approved Answer
3. List the names of employess who only work in projects located (PR_LOC) in New York (NY). 4. List the name of employess who work
3. List the names of employess who only work in projects located (PR_LOC) in New York (NY).
4. List the name of employess who work on all projects.
Question 2: SQL (40 points) Use the following database to answer all parts of this question: Table: EMP Primary Key: E NO E NO E NAME E DEPT E RATHE $400.00 $200.00 $150.00 $150.00 S120.00 $100.00 $100.00 $50.00 $50.00 $50.00 $150.00 3 10 Table: PART Primary Key: P NO P NO P NAME P1 P2 P3 P4. P5 P6 P CITY NY SF NY Table: PROJECT Primary Key: PR NOStep 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