Week 4.1 - Missing data

Please use Canvas to return the assignments: https://ucsb.instructure.com/courses/32934/assignments/472151

Which sites have no egg data? Please answer this question using the two 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.

Add an ORDER BY clause to your queries so that the two queries 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: 20 points