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
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
Get step-by-step solutions from verified subject matter experts
