---
# System prepended metadata

title: Data Analytics on Youtube API via SQL

---

# 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
![](https://hackmd.io/_uploads/B1mvojLE2.png)

## Result
![](https://hackmd.io/_uploads/SkAhsoLVn.png)

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


## SQL code
![](https://hackmd.io/_uploads/B1U6ojIEn.png)


## Result
![](https://hackmd.io/_uploads/ByxRijL42.png)


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


## SQL code
![](https://hackmd.io/_uploads/SyLRioLVn.png)

## Result
![](https://hackmd.io/_uploads/SynRjiI4h.png)

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


## SQL code
![](https://hackmd.io/_uploads/By-Jno8En.png)

## Result
![](https://hackmd.io/_uploads/r1_k2j84h.png)
