Answered step by step
Verified Expert Solution
Question
1 Approved Answer
17 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 74211300 7369
17 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 74211300 7369 20 7566 2250 7421 2 100 80 3 points SELECT e.emp_id, d.Dept_id FROM emp e LEFT OUTER JOIN emp_dept ed ON e.emp_id = ed.emp_id INNER JOIN Dept d ON d.Dept_id = ed.Dept_id; Result set 6 O Result set 4 Dept_id Dept Name RandD IT HR OOOO Result set 2 Result set 3 Result set 1 Result set 5 Match the following queries with the outputs (not all results need to be matched and some results may be repeated) Result set 1 Result set 2 Result set 3 emp_id] Dept_id emp_id Dept_id emp_id] Dept_id 7369 7369 | 1 7369 1 7421 | 2 7369 2 7369 2 7421 | 2 7566| Result set 4 Result set 5 Result set 6 emp_id] Dept_id emp_id | Dept_id emp_id] Dept_id 7369 7369 | 7369 1 7369 7369 7369 | 2 7421 7421 2 7421 | 2 7566 |
Step 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