Homework: Practice on baby names (optional)

Using the 2015 states+specific babyname set, run all of these queries, but run them with state='US' (to count nationwide names only)

• 10 most popular names overall
• 5 most popular boy names
• 5 most popular names that begin with 'Mich'
• 5 most popular names with exactly 6 characters that begin with the letters "Ja"
• 5 most popular girl names with 4 or fewer characters
• 3 most popular names that begin with 'Z'
• 3 most popular names with at least 2 consecutive "r" letters
• 5 most popular girl names that end in a vowel
• 5 most popular girl names that don't end in a vowel
• 5 most popular boy names that begin and end in vowels
• The 5 longest names, sorted by popularity
• 5 longest names with at least 1,000 babies

Aggregates

• Number of rows in the babynames table
• Number of total babies in the babynames table
• Number of unique names
• Number of names with more than 10,000 babies
• Total number of girl names and babies
• Total number of names and babies, boys versus girls

Answers are from last year.