Screen Link:
https://app.dataquest.io/m/253/summary-statistics/8/counting-unique-values
how do I find the number of rows that fall under a unique category?
for instance, i can use SELECT DISTINCT to print a list of distinct major categories.
however, the result i want is this:
engineering: 40
business: 25
how do i go about that?
That’s something that will be covered in the next mission, Group Summary Statistics.
You will learn about the GROUP BY clause and how to use/apply it. It essentially “groups” the data based on the categories in a specific column.
If you would still like to see the code on how to do this, let me know, and I can post that here. It’s great that you are thinking ahead and trying different things out, but you can also consider waiting if you’d like!