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 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!