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```

Computer Science & Information Technology

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

Computer Science & Information Technology

Synchronous Scrolling can be turned off

Indicate whether the statement is true or false

Computer Science & Information Technology

The different colors of the laser signals feature different __________.

A. wavelengths B. speeds C. temperatures D. noise levels

Computer Science & Information Technology

A cell reference is the column and ____ location of a cell.

A. block B. grid C. row D. line

Computer Science & Information Technology