List the sections taught by instructors who do not live in New Jersey, showing instructor and state along with course and section numbers. (78 rows)
What will be an ideal response?
```
SELECT i.last_name, z.state, s.course_no, s.section_no
FROM section s, instructor i, zipcode z
WHERE s.instructor_id = i.instructor_id
AND i.zip = z.zip
AND z.state <> 'NJ'
ORDER BY i.last_name, s.course_no, s.section_no
```
Computer Science & Information Technology
You might also like to view...
WordArt color styles CANNOT be modified
Indicate whether the statement is true or false
Computer Science & Information Technology
Medical facilities cannot release information regarding a patient unless the patient has signed a ____________________ form.
Fill in the blank(s) with the appropriate word(s).
Computer Science & Information Technology