Use SQL categorization and ranking techniques to explore 101 years of American baby name tastes.
What makes a name timeless or trendy? In this project, you'll use data published by the U.S. Social Security Administration spanning over a hundred years to understand American baby name tastes.
The ranking, grouping, joining, ordering, and pattern matching skills you'll use in this project are broadly applicable: understanding changing tastes is a key competency for businesses as well as parents searching for a baby name!
- Classic American names
- Timeless or trendy?
- Top-ranked female names since 1920
- Picking a baby name
- The Olivia expansion
- Many males with the same name
- Top male names over the years
- The most years at number one