American Baby Name Trends
SQL
Personal Project

• Accomplished identification of timeless names measured by their presence in the dataset over 101 years, using advanced SQL querying skills to analyze all 12,650 rows and pinpoint names consistently used every year.

• Analyzed the distinction between timeless and trendy names measured by longevity and fluctuations in usage, utilizing SQL to categorize names based on their persistence and variance in popularity over time.

• Identified top-ranked female names since 1920 measured by annual popularity rankings.

• Uncovered popular girl names ending with 'a' since 2015 measured by frequency and rank, applying SQL skills to filter and analyze trends for these specific names within the dataset.

• Traced the rise in popularity of the name 'Olivia' measured by yearly data points, leveraging SQL to analyze the ascent of this name in the dataset and pinpoint when it became a top choice.

• Determined the highest number of male babies given the same name each year measured by the maximum occurrence, using SQL to meticulously calculate the most frequently chosen male name annually.

• Compiled the top male name for each year in the dataset measured by rank and frequency, executing SQL queries to continuously identify the most popular male names each year.

• Identified which name was number one for the most years measured by the frequency of appearance at the top rank.

​

Questions answered: 

1. What are the names that have been present all 101 years? 

2. Is a name "Timeless" or "Trendy"?

3. What are the top-ranked female names since 1920?

4. What girl names end with the letter "a" that have been popular since 2015?

5. When did the name 'Olivia' become so popular?

6.  What is the highest number of male babies given the same name for each year?

7. What is the top male name for each year in our dataset?

8. Which name (from the previous question) has been number one for the largest number of years?