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


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.


158 views0 comments


bottom of page