List all zip codes that are not assigned to students. Write two versions: using a NOT EXISTS and using an OUTER JOIN.
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```
You might also like to view...
________ view displays tasks, task durations, and task dependencies and is the default view in Project 2013
A) Backstage B) Network Diagram C) Gantt Chart D) Calendar
Synchronous Scrolling can be turned off
Indicate whether the statement is true or false
The different colors of the laser signals feature different __________.
A. wavelengths B. speeds C. temperatures D. noise levels
A cell reference is the column and ____ location of a cell.
A. block B. grid C. row D. line