Lab 12: SQL
Due at 11:59pm on Friday, 04/20/2018.
Starter Files
Download lab12.zip. Inside the archive, you will find starter files for the questions in this lab, along with a copy of the Ok autograder.
Submission
By the end of this lab, you should have submitted the lab with
python3 ok --submit
. You may submit more than once before the
deadline; only the final submission will be graded.
Check that you have successfully submitted your code on
okpy.org.
- To receive credit for this lab, you must complete Questions 2-4 in lab12.sql, and submit through OK.
- Questions 5-6 are considered extra practice. They can be found in the lab12_extra.sql file. It is recommended that you complete these when you are finished with the required questions.
- Questions 7-8 are also considered extra practice. They can be found in the lab12_extra.sql file. It is recommended that you complete them on your own time.
SQLite
Setup
The simplest way to start using SQLite is to download a precompiled binary from the SQLite website. The latest version of SQLite at the time of writing is 3.20.0, but you can check for additional updates on the website.
Windows
- Visit the download page linked above and navigate to the section Precompiled Binaries for Windows. Click on the link sqlite-tools-win32-x86-*.zip to download the binary.
- Unzip the file. There should be a
sqlite3.exe
file in the directory after extraction. Navigate to the folder containing the
sqlite3.exe
file and check that the version is at least 3.8.3:$ cd path/to/sqlite $ ./sqlite3 --version 3.12.1 2016-04-08 15:09:49 fe7d3b75fe1bde41511b323925af8ae1b910bc4d
macOS Yosemite (10.10) or newer
SQLite comes pre-installed. Check that you have a version that's greater than 3.8.3:
$ sqlite3
SQLite version 3.8.10.2
Mac OS X Mavericks (10.9) or older
SQLite comes pre-installed, but it is the wrong version.
- Visit the download page linked above and navigate to the section Precompiled Binaries for Mac OS X (x86). Click on the link sqlite-tools-osx-x86-*.zip to download the binary.
- Unzip the file. There should be a
sqlite3
file in the directory after extraction. Navigate to the folder containing the
sqlite3
file and check that the version is at least 3.8.3:$ cd path/to/sqlite $ ./sqlite3 --version 3.12.1 2016-04-08 15:09:49 fe7d3b75fe1bde41511b323925af8ae1b910bc4d
Ubuntu
The easiest way to use SQLite on Ubuntu is to install it straight from the native repositories (the version will be slightly behind the most recent release):
$ sudo apt-get install sqlite3
$ sqlite3 --version
3.8.6 2014-08-15 11:46:33 9491ba7d738528f168657adb43a198238abde19e
Usage
Note: If you downloaded a precompiled binary above, make sure that
sqlite3.exe
file is in the same directory as your.sql
file. (Extract and move it out from the zip file you downloaded.)
After writing your code in the .sql
file, you can test and verify
your output in Terminal or Git Bash with one of the two following
commands.
1.) Runs your code and then exits SQLite immediately afterwards.
Ubuntu / Mac OS X (Yosemite or newer)
sqlite3 < lab12.sql
Windows / Mac OS X (Mavericks or older)
./sqlite3 < lab12.sql
2.) Runs your code and keeps SQLite open for further commands, which
is similar to running Python code with the interactive -i
flag.
You can type .help
to see some of the commands you can run.
Ubuntu / Mac OS X (Yosemite or newer)
sqlite3 --init lab12.sql
Windows / Mac OS X (Mavericks or older)
./sqlite3 --init lab12.sql
To exit out of SQLite after using the second command, type .exit
or .quit
or you can hit
Ctrl-C
. Also if you see ...>
you probably forgot a ;
Topics
SQL Basics
Creating Tables
You can create SQL tables either from scratch or from existing tables.
Below creates the table from scratch, without referencing any other existing tables.
CREATE TABLE [table_name] AS
SELECT [val1] AS [column1], [val2] AS [column2], ... UNION
SELECT [val3] , [val4] , ... UNION
SELECT [val5] , [val6] , ...;
Note: You do not need to repeat the
AS
keyword in subsequent SELECT statements when creating the table.
Here is an example where we construct a table with the CREATE TABLE
statement. UNION
is used here to join rows and AS
assigns a table column to a new name.
CREATE TABLE Football AS
SELECT 30 AS Berkeley, 7 AS Stanford, 2002 AS Year UNION
SELECT 28, 16, 2003 UNION
SELECT 17, 38, 2014;
Here we have created a table called Football
, which has three attributes
(columns): Berkeley
, Stanford
, and Year
. We can later access the
values from this table by referencing the table's columns.
To create tables from existing tables, the SELECT
command references
another table.
Selecting From Tables
More commonly, we will create new tables by selecting specific columns
that we want from existing tables. SELECT
statements can include optional
clauses such as:
FROM
: tells SQL which tables to select values fromWHERE
: filters by some conditionORDER BY
: enforces an ordering by some attribute or attributes (usually a column or columns)LIMIT
: limits the number of rows in the output tableSELECT [columns] FROM [tables] WHERE [condition] ORDER BY [attributes] LIMIT [limit];
Notes about the arguments:
[columns]
: a comma separated list of the columns to select,*
can be used to select all of them[tables]
: a comma separated list of tables to select values from[condition]
: a Boolean expression[attributes]
: a comma separated list of attributes, which are usually columns, but could also be named aggregates (which we will learn later)[limit]
: an integer
We can select all the values of an attribute from a table with the SELECT
statement. In addition, we can apply a filter using the WHERE
clause. Here,
we filter by Year > 2002
, which makes the SELECT
statement keep only the
rows in the table whose Year
value is greater than 2002.
sqlite> SELECT Berkeley FROM Football WHERE Year > 2002;
17
28
Here we selected Berkeley's score for all years after 2002.
Expressions in SQL
Here are some fundamental operations you can perform:
- comparisons:
=
,>
,<
,<=
,>=
,<>
("not equal") - booleans:
AND
,OR
- arithmetic:
+
,-
,*
,/
We can also perform string concatenation using ||
, which behaves
similarly to +
on strings in Python.
sqlite> SELECT "hello" || " " || "world";
hello world
Note we capitalize SQL syntax purely for style. It makes it much easier to read, though will work if you don't capitalize it.
Joins
We can use joins to include rows from another table that satisfy the WHERE
predicate. Joins can either be on different tables, or the same table if we
include an alias. Here we are referencing the football table twice, using AS
to bind the football table once as the alias a
and once as the alias b
.
sqlite> SELECT b.Berkeley - a.Berkeley, b.Stanford - a.Stanford, a.Year, b.Year
...> FROM Football AS a, Football AS b WHERE a.Year < b.Year;
-11|22|2003|2014
-13|21|2002|2014
-2|9|2002|2003
What is this query asking for?
You may notice that it does not seem like we actually performed any operations
to do the join. However, the join is implicit in the fact that we listed more
than one table after the FROM. In this example, we joined the table Football
with itself and gave each instance of the table an alias, a
and b
so that
we could distinctly refer to each table's attributes and perform selections and
comparisons on them, such as a.Year < b.Year
.
One way to think of a join is that it produces a cross-product between the two tables by matching each row from the first table with every other row in the second table, which creates a new, larger joined table.
Here's an illustration of what happened in the joining process during the above query.
From here, the select statement examines the joined table and selects the values
it desires: b.Berkeley - a.Berkeley
and b.Stanford - a.Stanford
but only
from the rows WHERE a.Year < b.Year
. This prevents duplicate results from
appearing in our output and also removes rows where the years are the same.
Required Questions
Getting to Know Your Fellow 61A Students
This past weekend, we asked you and your fellow students to complete a brief online survey through Google Forms, which involved relatively random but fun questions. In this lab, we will interact with the results of the survey by using SQL queries to see if we can find interesting things in the data.
First, take a look at sp18data.sql
and examine the table defined in it. Note
its structure. You will be working with:
students
: The main results of the survey. Each column represents a different question from the survey, except for the first column, which is the time of when the result was submitted. This time is a unique identifier for each of the rows in the table.Column Name Question time
The unique timestamp that identifies the submission number
What's your favorite number between 1 and 100? color
What is your favorite color? seven
Choose the number 7 below.
Options:- 7
- You're not the boss of me!
- Choose this option instead
- seven
- the number 7 below.
song
If you could listen to only one of these songs for the rest of your life, which would it be?
Options:- "Smells Like Teen Spirit" by Nirvana
- "The Middle" by Zedd
- "Fur Elise" by Ludwig van Beethoven
- "Finesse ft. Cardi B" by Bruno Mars
- "God's Plan" by Drake
- "Down With The Sickness" by Disturbed
- "Everytime We Touch" by Cascada
date
Pick a day of the year! pet
If you could have any animal in the world as a pet, what would it be? denero
Choose your favorite photo of John DeNero! (Options shown under Question 2) smallest
Try to guess the smallest unique positive INTEGER that anyone will put! checkboxes
: The results from the survey in which students could select more than one option from the numbers listed, which ranged from 0 to 10 and included 2018, 9000, and 9001. Each row has a time (which is again a unique identifier) and has the value'True'
if the student selected the column or'False'
if the student did not. The column names in this table are the following strings, referring to each possible number:'0'
,'1'
,'2'
,'4'
,'5'
,'6'
,'7'
,'8'
,'9'
,'10'
,'2018'
,'9000'
,'9001'
.
Since the survey was anonymous, we used the timestamp that a survey was
submitted as a unique identifier. A time in students
matches up with a time
in checkboxes
. For example, the row in students
whose time
value is
"4/13/2018 15:25:03"
matches up with the row in checkboxes
whose time
value is "4/13/2018 15:25:03"
. These entries come from the same Google form
submission and thus belong to the same student.
Note: If you are looking for your personal response within the data, you may have noticed that some of your answers are slightly different from what you had input. In order to make SQLite accept our data, and to optimize for as many matches as possible during our joins, we did the following things to clean up the data:
color
andpet
: We converted all the strings to be completely lowercase.- For some of the more "free-spirited" responses, we escaped the special characters so that they could be properly parsed.
You will write all of your solutions in the starter file lab12.sql
provided. As with other
labs, you can test your solutions with OK. In addition, you can use either of
the following commands. You may need to refer to the Usage section to find the
appropriate command for your OS:
sqlite3 < lab12.sql
sqlite3 --init lab12.sql
Q1: What Would SQL print?
First, load the tables into sqlite3. If you're on Windows or Mac OS X (Mavericks or older), use the following command:
$ ./sqlite3 --init lab12.sql
If you're on Ubuntu or Mac OS X (Yosemite or newer), use:
$ sqlite3 --init lab12.sql
Before we start, inspect the schema of the tables that we've created for you:
sqlite> .schema
This tells you the name of each of our tables and their attributes.
Let's also take a look at some of the entries in our table. There are a lot of entries though, so let's just output the first 20:
sqlite> SELECT * FROM students LIMIT 20;
If you're curious about some of the answers students put into the Google form,
open up sp18data.sql
in your favorite text editor and take a look!
For each of the SQL queries below, think about what the query is looking for, then try running the query yourself and see!
sqlite> SELECT * FROM students; -- This is a comment. * is shorthand for all columns!
______selects all records from students;
sqlite> SELECT color FROM students WHERE number = 16;
______selects the color from students who said their favorite number was 16;
sqlite> SELECT song, pet FROM students WHERE color = "blue" AND date = "12/25";
______selects the song and pet from students who said their favorite color was blue and picked December 25th;
Remember, to exit out of SQLite after using the second command, type .exit
or .quit
or hit
Ctrl-C
. Also, if you see ...>
you probably forgot a ;
Q2: Obedience
To warm-up, let's ask a simple question related to our data: Is there a correlation between whether students do as they're told and their favorite images of the instructor?
Write an SQL query to create a table that contains the columns seven
(this
column representing "obedience") and denero
(the image of Professor DeNero
students selected) from the students
table.
You should get the following output:
sqlite> SELECT * FROM obedience LIMIT 10;
7|Image 1
7|Image 5
the number 7 below.|Image 1
7|Image 2
7|Image 2
the number 7 below.|Image 1
the number 7 below.|Image 5
7|Image 1
You're not the boss of me!|Image 4
7|Image 4
CREATE TABLE obedience AS
SELECT "REPLACE THIS LINE WITH YOUR SOLUTION";
SELECT seven, denero FROM students;
Use Ok to test your code:
python3 ok -q obedience
Q3: The Smallest Unique Positive Integer
Who successfully managed to guess the smallest unique positive integer value? Let's find out!
Unfortunately we have not learned how to do aggregations in SQL, which can help us count the number of times a specific value was selected, just yet. As such, we can only hand inspect our data to determine it. However, an anonymous elf has informed us that the smallest unique positive value is greater than 15!
Write an SQL query to create a table with the columns time
and smallest
that we can inspect to determine what the smallest integer value is. In order
to make it easier for us to inspect these values, use WHERE
to restrict the
answers to numbers greater than 15, ORDER BY
to sort the numerical values,
and LIMIT
your result to the first 20 values that are greater than the number
15.
The first 5 lines of your output should look like this:
sqlite> SELECT * FROM smallest_int LIMIT 5;
4/13/2018 15:16:12|16
4/13/2018 15:22:11|16
4/13/2018 15:15:08|17
4/13/2018 15:18:10|17
4/13/2018 15:21:43|17
4/13/2018 15:22:13|17
CREATE TABLE smallest_int AS
SELECT "REPLACE THIS LINE WITH YOUR SOLUTION";
SELECT time, smallest FROM students WHERE smallest > 15 ORDER BY smallest LIMIT 20;
Use Ok to test your code:
python3 ok -q smallest-int
After you've successfully passed the Ok test, take a look at the table
smallest_int
that you just created and manually find the smallest unique
integer value! If you're curious how to do this with aggregations, check out
Question 8.
To do this, try the following:
$ sqlite3 --init lab12.sql
sqlite> SELECT * FROM smallest_int; -- No LIMIT this time!
Q4: Matchmaker, Matchmaker
Did you take 61A with the hope of finding your soul mate? Well you're in luck! With all this data in hand, it's easy for us to find your perfect match. If two students want the same pet and have the same taste in music, they are clearly meant to be together! In order to provide some more information for the potential lovebirds to converse about, let's include the favorite colors of the two individuals as well!
In order to match up students, you will have to do a join on the students
table
with itself. When you do a join, SQLite will match every single row with every single
other row, so make sure you do not match anyone with themselves, or match any given pair
twice!
Important Note: When pairing the first and second person, make sure that the first person responded first (i.e. they have an earlier
time
). This is to ensure your output matches our tests.
Hint: When joining table names where column names are the same, use dot notation to distinguish which columns are from which table:
[table_name].[column name]
. This sometimes may get verbose, so it’s stylistically better to give tables an alias using theAS
keyword. The syntax for this is as follows:SELECT <[alias1].[column name1], [alias2].[columnname2]...> FROM <[table_name1] AS [alias1],[table_name2] AS [alias2]...> ...
The query in the football example from earlier uses this syntax.
Write a SQL query to create a table that has 4 columns:
- The shared preferred
pet
of the couple - The shared favorite
song
of the couple - The favorite
color
of the first person - The favorite
color
of the second person
You should get the following output:
sqlite> SELECT * FROM matchmaker LIMIT 10;
wolf|Fur Elise|green|blue
cat|Smells Like Teen Spirit|purple|purple
cat|Smells Like Teen Spirit|purple|green
cat|Smells Like Teen Spirit|purple|blue
dog|Finesse|navy|red
dog|Finesse|navy|mint
dog|Finesse|navy|blue
dog|Finesse|navy|blue
elephant|The Middle|purple|yellow
dog|Finesse|red|mint
CREATE TABLE matchmaker AS
SELECT "REPLACE THIS LINE WITH YOUR SOLUTION";
SELECT a.pet, a.song, a.color, b.color FROM students AS a, students AS b
WHERE a.time < b.time AND a.pet = b.pet AND a.song = b.song;
Use Ok to test your code:
python3 ok -q matchmaker
Optional Questions
The following questions are for extra practice -- they can be found in the lab12_extra.sql file. It is recommended that you complete these problems, but you do not need to turn them in for credit.
Q5: Great Students Think Alike
We administered a similar survey for Lab 12 last semester to 61A students (see
the table fa17students
in fa17data.sql
).
The only question that has been removed is hilfinger
, so let's play around
with this data using joins!
Great students think alike. We want to print out the information of students
that have the same favorite date
, color
and pet
! How do their favorite
number
s differ?
Write a SQL query to create a table that has 5 columns:
- The shared favorite
date
between semesters - The shared favorite
color
between semesters - The shared favorite
pet
between semesters - The favorite
number
of this semester's student - The favorite
number
of last semester's student
You should get the following output:
sqlite> SELECT * FROM greatstudents;
2/29|blue|dragon|69|12
12/25|blue|dog|17|7
12/25|blue|dog|17|15
1/1|green|dog|3|7
1/1|blue|dog|11|60
4/20|white|sloth|11|69
1/1|black|dog|1|1
12/25|blue|tiger|17|21
CREATE TABLE greatstudents AS
SELECT "REPLACE THIS LINE WITH YOUR SOLUTION";
SELECT a.date, a.color, a.pet, a.number, b.number FROM students AS a, fa17students AS b
WHERE a.date = b.date AND a.color = b.color AND a.pet = b.pet;
Use Ok to test your code:
python3 ok -q greatstudents
After you've successfully passed the Ok test, play around some more with joins to see what cool connections you can draw between the data from both semesters!
Q6: Sevens
Let's take a look at data from both of our tables, students
and checkboxes
,
to find out if students that really like the number 7 also chose '7'
for the
obedience question. Specifically, we want to look at the students that fulfill
the below conditions and see if they also chose '7'
in the question that asked
students to choose the number 7 (column seven
in students
).
Conditions:
- reported that their favorite number (column
number
instudents
) was 7 - have
'True'
in column'7'
incheckboxes
, meaning they checked the number7
during the survey
In order to examine rows from both the students
and the checkboxes
table, we will
need to perform a join.
How would you specify the WHERE
clause to make the SELECT
statement only consider
rows in the joined table whose values all correspond to the same student? If
you find that your output is massive and overwhelming, then you are probably missing
the necessary condition in your WHERE
clause to ensure this.
Note: The columns in the
checkboxes
table are strings with the associated number, so you must put quotes around the column name to refer to it. For example if you alias the table asa
, to get the column to see if a student checked 9001, you must writea.'9001'
.
Write a SQL query to create a table with just the column seven
from students
, filtering
first for students who said their favorite number (column number
) was 7 in the students
table and who checked the box for seven (column '7'
) in the checkboxes
table.
The first 10 lines of this table should look like this:
sqlite> SELECT * FROM sevens LIMIT 10;
7
7
7
You're not the boss of me!
7
seven
the number 7 below.
You're not the boss of me!
7
7
CREATE TABLE sevens AS
SELECT "REPLACE THIS LINE WITH YOUR SOLUTION";
SELECT s.seven FROM students AS s, checkboxes AS c WHERE s.number = 7 AND c.'7' = 'True' AND s.time = c.time;
Use Ok to test your code:
python3 ok -q sevens
The COUNT Aggregator
How many people liked each pet? What is the biggest date chosen this semester? How many obedient people chose Image 1 for Professor DeNero or Professor Hilfinger? Is there a difference between last semester's average favorite number and this semester's?
To answer these types of questions, we can bring in SQL aggregation, which allows us to accumulate values across rows in our SQL database!
In order to perform SQL aggregation, we can group rows in our table by one or more attributes. Once we have groups, we can aggregate over the groups in our table and find things like:
- the maximum value (
MAX
), - the minimum value (
MIN
), - the number of rows in the group (
COUNT
), - the average over all of the values (
AVG
),
and more!
SELECT
statements that use aggregation are usually marked by two things: an
aggregate function (MAX
, MIN
, COUNT
, AVG
, etc.) and a GROUP BY
clause.
GROUP BY [column(s)]
groups together rows with the same value in each
column(s).
In this section we will only use COUNT
, which will count the number of rows
in each group, but feel free to check out this
link for more!
For example, the following query will print out the top 10 favorite numbers with their respective counts:
sqlite> SELECT number, COUNT(*) AS count FROM students GROUP BY number
ORDER BY count DESC LIMIT 10;
69|31
7|19
4|13
17|13
42|12
1|11
3|10
9|10
11|9
12|9
This SELECT
statement first groups all of the rows in our table students
by number
. Then, within each
group, we perform aggregation by COUNT
ing all the rows. By selecting number
and COUNT(*)
,
we then can see the highest number
and how many students picked that number. We have to order by our COUNT(*)
, which is saved in the alias count
, by DESC
ending order, so our highest count starts at the top, and we limit our result to the top 10.
Q7: Let's Count
Let's have some fun with this! For each query below, we created its own table inlab12_extra.sql
, so fill in the corresponding table and run it using Ok.
Try working on this on your own or with a neighbor before toggling to see the
solutions.
Hint: You may find that there isn't a particular attribute you should have to perform the
COUNT
aggregation over. If you are only interested in counting the number of rows in a group, you can just sayCOUNT(*)
.
What was the favorite number from last semester?
sqlite> SELECT * FROM fa17favnum;
69|66
CREATE TABLE fa17favnum AS
SELECT "REPLACE THIS LINE WITH YOUR SOLUTION";
SELECT number, COUNT(*) AS count FROM fa17students
GROUP BY number ORDER BY count DESC LIMIT 1;
What were the top 10 pets last semester?
sqlite> SELECT * FROM fa17favpets;
dog|57
cat|33
dragon|14
panda|14
tiger|14
lion|13
penguin|12
dolphin|10
john denero|9
elephant|8
CREATE TABLE fa17favpets AS
SELECT "REPLACE THIS LINE WITH YOUR SOLUTION";
SELECT pet, COUNT(*) AS count FROM fa17students
GROUP BY pet ORDER BY count DESC LIMIT 10;
What are the top 10 pets this semester?
sqlite> SELECT * FROM sp18favpets;
dog|47
cat|20
tiger|16
panda|11
dragon|9
dolphin|5
elephant|5
hedgehog|5
monkey|5
capybara|4
CREATE TABLE sp18favpets AS
SELECT "REPLACE THIS LINE WITH YOUR SOLUTION";
SELECT pet, COUNT(*) AS count FROM students
GROUP BY pet ORDER BY count DESC LIMIT 10;
How many people marked exactly the word 'dog' as their ideal pet this semester?
sqlite> SELECT * FROM sp18dog;
dog|47
CREATE TABLE sp18dog AS
SELECT "REPLACE THIS LINE WITH YOUR SOLUTION";
SELECT pet, COUNT(*) FROM students WHERE pet = 'dog';
Although close, our query doesn't give us an entirely accurate picture of what people's favorite pets are.
For example, a dog
would not be counted the same as dog
. Let's see how many people actually want
a dog this semester by using LIKE
, which compares substrings. We can use it inside WHERE
, as in
WHERE [column_name] LIKE '%[word]%'
to find how many people would like some type of dog.
sqlite> SELECT * from sp18alldogs;
dog|55
CREATE TABLE sp18alldogs AS
SELECT "REPLACE THIS LINE WITH YOUR SOLUTION";
SELECT pet, COUNT(*) FROM students WHERE pet LIKE '%dog%';
We can find the student's favorite for any column (try it yourself in the
interpreter), but let's go back to our Obedience question. Let's see how many
obedient students this semester picked each image of Professor Denero. We can
do this by selecting only the rows that have seven = '7'
then GROUP BY denero
,
and finally we can COUNT
them.
sqlite> SELECT * FROM obedienceimages LIMIT 5;
7|Image 1|24
7|Image 2|28
7|Image 3|19
7|Image 4|39
7|Image 5|12
CREATE TABLE obedienceimages AS
SELECT "REPLACE THIS LINE WITH YOUR SOLUTION";
SELECT seven, denero, COUNT(*) FROM students WHERE seven = '7'
GROUP BY denero;
The possibilities are endless, so have fun experimenting!
Use Ok to test your code:
python3 ok -q lets-count
Q8: The Smallest Unique Positive Integer (Part 2)
Now, let's revisit the previous problem of finding the smallest positive integer that anyone chose, and take
a closer look at the COUNT
aggregate.
Write a SQL query that uses the COUNT
aggregate to create a table that pairs the attribute smallest
with
the number of times it was chosen by a student (this is the aggregation part).
Hint: Think about what attribute you need to
GROUP BY
.
After you've defined your table, you should get something like:
sqlite> SELECT * FROM smallest_int_count LIMIT 25;
1|101
2|13
3|10
4|9
5|5
6|7
7|6
8|3
9|4
10|6
11|5
12|7
13|5
14|3
15|2
16|2
17|11
18|1
19|3
20|1
21|2
22|6
23|12
24|1
25|3
CREATE TABLE smallest_int_count AS
SELECT "REPLACE THIS LINE WITH YOUR SOLUTION";
SELECT smallest, COUNT(*) FROM students GROUP BY smallest;
Use Ok to test your code:
python3 ok -q smallest-int-count
It looks like the number 18
only had one person choose it! Were you the lucky
student that put it down?