(Solved): Outer join expressions can be computed in SQL without using the SQL OUTER JOIN operation. To illus ...

Outer join expressions can be computed in SQL without using the SQL OUTER JOIN operation. To illustrate this fact, show how to rewrite the following SQL query without using the OUTER JOIN expression by using the university schema. Query to Be Rewritten: SELECT * FROM student NATURAL LEFT OUTER JOIN takes; Rewritten Query: SELECT * FROM student NATURAL UNION SELECT ___, name, FROM student AS SS WHERE Blank # 1 Blank # 2 Blank # 3 Blank # 4 Blank # 5 inner EXISTS (SELECT ID on exists takes null tot cred, NULL, NULL, NULL, NULL, NULL FROM ___ AS TT WHERE TT.ID = SS.ID); > A A/ A