The “sample answer tables” I gave for each question in the extra credit activity are only intended to give the shape of the answer, not any actual answer on any particular database. Apparently I posted a previous version of my SQLite Ben & Jerry’s database at some point, and some students were entering their queries against that database and expecting to come up with the same numerical answers as on the activity. Do not expect this to be the case.

(Btw, I intended this activity to be a pencil-and-paper affair where you figured out the correct query by looking at the schema page we’ve been using in class, not a use-the-computer affair where you typed SQL queries at the SQLite prompt. I guess now that people are doing it that second way, I can’t really outlaw it, but it wasn’t my intent.)