Question: Use the schemas below to provide the following SQL queries: course (course_id, title) prereq (course_id, prereq_id) Rewrite the following query WITHOUT using JOIN syntax: select
Use the schemas below to provide the following SQL queries: course (course_id, title) prereq (course_id, prereq_id)
Rewrite the following query WITHOUT using JOIN syntax:
select c.course_id, c.title, null
from course c
where not exists
(
select * from prereq p
where c.course_id = p.course_id
)
union all
select p.course_id, null, p.prereq_id
from prereq p
where not exists
(
select *
from course c
where p.course_id = c.course_id
)
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
