Homework: Practice on baby names (optional)
Exercises from last year
Table of contents
Tuesday, November 1 at 1:30 PM
0 Homework points
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
- 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.