Week 4 - Missing data

Please use Canvas to return the assignments: https://ucsb.instructure.com/courses/26293/assignments/359037

Which sites have no egg data? Please answer this question using all three techniques demonstrated in class. In doing so, you will need to work with the Bird_eggs table, the Site table, or both. As a reminder, the techniques are:

Using a Code NOT IN (subquery) clause.
Using an outer join with a WHERE clause that selects the desired rows. Caution: make sure your IS NULL test is performed against a column that is not ordinarily allowed to be NULL. You may want to consult the database schema to remind yourself of column declarations.
Using the set operation EXCEPT.

Add an ORDER BY clause to your queries so that all three produce the exact same result:

┌─────────┐
│  Code   │
│ varchar │
├─────────┤
│ barr    │
│ burn    │
│ bylo    │
│ cakr    │
│ cari    │
│ chau    │
│ coat    │
│ colv    │
│ iglo    │
│ ikpi    │
│ lkri    │
│ made    │
│ nome    │
│ prba    │
├─────────┤
│ 14 rows │
└─────────┘

Submit your SQL.

Credit: 10 points