---
title: "2021-12"
date: 2021-12-30T11:57:38+08:00
draft: true
weight: 202112
---
# 十二月的报告

## 讲解 SQL

> written by: abc@example.com <br />


Let's play with the data! §
Counting stars §
The WatchEvent is the event when someone gives a star to a repo.

```
✎:) SELECT count() FROM github_events WHERE event_type = 'WatchEvent'

┌───count()─┐
│ 232118474 │
└───────────┘

1 rows in set. Elapsed: 0.034 sec. Processed 232.13 million rows, 232.13 MB (6.85 billion rows/s., 6.85 GB/s.)
```
There is no event when someone removes the star. This means that star removal is invisible, but it should be rare in any case, so we can calculate the approximate number of stars from these events.

## 图表
{{< metabase "https://meta.gharchive.live/public/question/dc789aac-b8f0-43f7-974c-c9bc0907b408" >}}

## 动图
{{<video "/video/intro.mov" >}}