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.
What will be an ideal response?
```
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'))
```
You might also like to view...
A(n) ________ is a preformatted file that is designed for a specific purpose which can be reused repeatedly
Fill in the blank(s) with correct word
Answer the following questions true (T) or false (F)
1. When the MUL BL instruction executes, the upper half of the product ends up in the AH register. 2. When the MUL BX instruction executes, the 32-bit product ends into the EAX register. 3. The destination operand of the IMUL instruction may be a memory operand.