Sep 22
In class, this brought me a good chuckle. We were discussing summary queries, and for some reason we went into using null in the WHERE clause.
Query:
SELECT first_name, last_name, customer_number
FROM customer
WHERE street IS NULL
Result set:
| first_name | last_name | customer_number |
|---|---|---|
| Sally | Adams | 412 |
Teacher: So, what does this say about Sally Adams?
Student: She’s homeless?
