top of page

Counting Prizes

Updated: May 1

Does the Nobel Prize Committee award the same number of prizes each year? Let's find out!Write a query to count the number of prizes for each year. Select the year and the count. Let's count some prizes! Note that you can use COUNT(*) to count the rows in each group.


Answer: SELECT year, COUNT (*)

FROM nobel_prizes

GROUP BY year


Ready to become a SQL wizard in record time? Dive into the world of databases with our SQL Bootcamp!



Whether you're a complete beginner or looking to brush up on your skills, "Mastering SQL" is your ticket to proficiency.





SQL

158 views0 comments

Comentários


bottom of page