SQL Counting/Sorting/Filtering (Questions)

Example queries to ask.


This page just contains questions. To see, the answers and explanation visit SQL Counting and Filtering Lesson

Baby names data from Social Security Administration

  • The first records (just name, sex, year) in the babynames database
  • Top 5 popular baby names of all time
  • Top 5 female babynames in 1991
  • How the female name “Jenny” compares to “Jennifer” in 2001
  • How the male names ‘Noah’, ‘Jordan’, and David compare, in 1980 and 2010
  • The 10 most popular names in 2009 that began with a vowel
  • The 10 most popular names in the year 2015 that begin with ‘Z’ and have at least 5 characters