Count and group

SQL can count and summarise. COUNT(*) counts rows. GROUP BY makes one row per group, so you can count within each group. AS names the new column:

SELECT paradigm, COUNT(*) AS total
FROM languages
GROUP BY paradigm;

That gives one row per paradigm, with how many languages are in it.

Your turn

For each paradigm, show the paradigm and how many languages use it, in a column named total. Order by paradigm.

Tables you can use

languages (name, year, paradigm, openings): one row per language. openings is the number of job openings, in thousands.

creators (language, creator): who created each language.

Your SQL

Press Run to see your results.

All SQL lessons Next: Averages and ROUND