List all sections (course_no, description, section_no) taught by instructors that do not live in Connecticut. Sort the result by course_no, section_no. (78 rows) Write two versions, and use a correlated subquery in one.

Question

What will be an ideal response?

Answer 1

```
SELECT s.course_no, s.section_no, c.description
FROM section s, course c, instructor i
WHERE s.course_no = c.course_no
AND i.instructor_id = s.instructor_id
AND i.zip NOT IN (SELECT zip
FROM zipcode
WHERE state ='CT')
```
```
SELECT s.course_no, s.section_no, c.description
FROM section s, course c
WHERE s.course_no = c.course_no
AND EXISTS (SELECT null
FROM instructor i
WHERE i.instructor_id = s.instructor_id
AND i.zip NOT IN (SELECT zip
FROM zipcode
WHERE state ='CT'))
```