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. 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...
As you create a presentation with illustrations, use the ___________________ to determine color choices.
Fill in the blank(s) with the appropriate word(s).
A conversion from a built-in data type to a class is made by using ____.
A. operator functions B. conversion methods C. class operators D. constructor methods
An IPv6 DHCP server that only passes out optional information (mainly DNS server addresses) is a(n) _______________ DHCPv6 server.
Fill in the blank(s) with the appropriate word(s).
Developed by Google, ____ is a mobile OS based on Linux designed to run on many types of smartphones and tablets.?
A. ?Android B. ?iOS C. ?Windows Phone D. ?Blackberry