Project in SQL to analyze how have American baby names changed since 1920 and understand the trends.
- Check which names stood out by summing the total babies with each first name, grouping by those names that appears in all 101 years
SQL Query:
Result:
- Categorize the names into 4 categories to capture the type of popularity for each name: "Trendy" when total qty is higher than 0, less than 20 "Semi-Trendy" when total qty is higher than 20, less than 50 "Semi-Classic" when total qty is higher than 50, less than 80 "Classic" when total qty is higher than 80, less than 80
SQL Query:
Result:
- Limit the search for female names and fing the top-10 female names since 1920.
SQL Query:
Result:
- Select a list of baby names that end with the letter 'a' using LIKE
SQL Query:
Result:
- Explore the rise of name "Olivia"
SQL Query:
Result:
- Check the maximum number of babies given any one male name in each year.
SQL Query:
Result:
- Find out what the top male name is for each year.
SQL Query:
Result:
- Find out which name has been number one for the largest number of years.
SQL Query:
Result:
