Question: Please solve using Oracle SQL database ASAP YU if you are glven the data of emp, emp dept and dept tables: Match the foloning queries

Please solve using Oracle SQL database
ASAP
 Please solve using Oracle SQL database ASAP YU if you are
glven the data of emp, emp dept and dept tables: Match the

YU if you are glven the data of emp, emp dept and dept tables: Match the foloning queries with the outputs (not all resalts need to be matched and se results may be repeated) LEFT OUTER JOIN emp dept ed ON e emp id ed.emp FROM emp ON d.Dept id - ed Dept id, LEFT OUTER JOIN Dept d ed emp id ON d.Dept_id- od Dept id FROM empe RIGHT OUTER JOIN emp dept ed ON e.emp id RIGHT OUTER JOIN Dept d e SELECT e emp id d.Dept kd NATURAL JOIN emp dept ed NATURAL JOIN Dept d; FROM emp e d SELECT eemp_ id, d.Dept id FROM emp e, emp dept ed, Dept d WHERE e emp-id ed.emp.id AND d.Dept id -ed.Dept_id e. SELECT e.emp-id, d. Dept-id FROM emp dept ed LEFT OUTER JOIN emp c ON e.emp id ed.emp_id LEFT OUTER JOIN Dept d ON d.Dept id-ed Dept_id E SELECT e.emp id, d.Dept id FROM emp e LEFT OUTER JOIN emp-dept cd LEFT OUTER JOIN Dept d ON e.emp-id =ed.emp-id ON d.Dept id-ed.Dept id UNION SELECT e.emp_ id, d.Dept id FROM emp e RIGHT OUTER JOIN emp _dept ed ON c.emp_id -ed.emp_ id RIGHT OUTER JOIN Dept d ON d.Dept id -ed.Dept id & SELECT ed.emp id, ed. Dept id FROM emp dept ed WHERE EXISTS (SELECT 1 FROM emp dept e WHERE c.emp id -ed emp id) AND Percentage time > 50

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!