Skip to content

Instantly share code, notes, and snippets.

@codecademydev

codecademydev/project.sqlite Secret

Created Feb 19, 2020
Embed
What would you like to do?
Codecademy export
--most common results of style quiz
SELECT DISTINCT style, COUNT (*) AS count_st
FROM quiz
GROUP BY 1
ORDER BY 2;
SELECT DISTINCT fit, COUNT (*) AS count_f
FROM quiz
GROUP BY 1
ORDER BY 2;
SELECT DISTINCT shape, COUNT (*) AS count_sh
FROM quiz
GROUP BY 1
ORDER BY 2;
SELECT DISTINCT color, COUNT (*) AS count_c
FROM quiz
GROUP BY 1
ORDER BY 2;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment