SQL Counting/Sorting/Filtering (Questions)

Example queries to ask.

Note

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