Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

20 Question 05 If you are given the data of emp, emp_dept and dept tables: emp_id sal emp_id Dept_id Percentage_time 7369 1250 7369 80 74211300

image text in transcribed

20 Question 05 If you are given the data of emp, emp_dept and dept tables: emp_id sal emp_id Dept_id Percentage_time 7369 1250 7369 80 74211300 7369 2 20 7566 2250 7421 i 2 i 100 3 points SELECT ed.emp_id, ed.Dept_id FROM emp_dept ed WHERE EXISTS (SELECT 1 FROM emp_depte WHERE e.emp_id = ed.emp_id) AND Percentage_time > 50; 0 Result set 2 Dept_id Dept Name RandD IT HR Result set 5 Result set 1 Result set 4 Result set 3 Result set 6 Match the following queries with the outputs (not all results need to be matched and some results may be repeated) Result set 2 Result set 1 Result set 3 emp_id] Dept_id emp_id Dept_id emp_id Dept_id 7369 7369 | 1 7369 | 1 7369 2 7421 | 2 7421 | 2 7369 2 75661 Result set 6 Result set 4 Result set 5 emp_id Dept_id emp_id Dept_id emp_id Dept_id 7369 | 1 7369 | 7369 7369 7369 | 2 2 7421 7421 7421 | 2 7566 | 73691

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

Database Principles Programming And Performance

Authors: Patrick O'Neil, Elizabeth O'Neil

2nd Edition

1558605800, 978-1558605800

More Books

Students also viewed these Databases questions

Question

What is the difference between Basel I, Basel II, and Basel III?

Answered: 1 week ago

Question

I am paid fairly for the work I do.

Answered: 1 week ago

Question

I receive the training I need to do my job well.

Answered: 1 week ago