List all zip codes that are not assigned to students. Write two versions: using a NOT EXISTS and using an OUTER JOIN. (82 rows)
What will be an ideal response?
```
SELECT zip
FROM zipcode z
WHERE NOT EXISTS (SELECT null
FROM student s
WHERE s.zip=z.zip)
```
```
SELECT z.zip
FROM zipcode z, student s
WHERE z.zip = s.zip (+)
AND s.zip IS NULL
```
```
SELECT z.zip
FROM zipcode z LEFT OUTER JOIN student s
ON z.zip = s.zip
WHERE s.zip IS NULL
```
Computer Science & Information Technology
You might also like to view...
When you enable ______, an enclosing frame automatically becomes larger when you move an enclosed object beyond the enclosing frame's boundary.
Fill in the blank(s) with the appropriate word(s).
Computer Science & Information Technology
Experiment with the Web form example presesnted in Figures ...
What will be an ideal response?
Computer Science & Information Technology