Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

image text in transcribed

image text in transcribed

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 NO

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Accidental Data Scientist

Authors: Amy Affelt

1st Edition

1573877077, 9781573877077

More Books

Students also viewed these Databases questions

Question

LO2 Discuss the constraints faced in a typical recruitment process.

Answered: 1 week ago