# Data Analytics on Youtube API via SQL

# the complete code can be seen from my GitHub
https://github.com/Liao993/youtuber_api_sql.git

# Finding 1 : Calculate the number of videos uploded each year

## SQL code

## Result

# Finding 2 : find top 10 video with the most view_count and show its upload_date and rank

## SQL code

## Result

# Finding 3 : find top 10 video with the most like_count and show its upload_date and rank

## SQL code

## Result

# Finding 4 : list the top 20 videos on video leaderboard, and see their ranking situations on like_count leaderboard

## SQL code

## Result