728x90
prolific_commenters_query = """SELECT author, COUNT(id) AS NumPosts
FROM `bigquery-public-data.hacker_news.comments`
GROUP BY author
HAVING COUNT(id) > 10000"""deleted_posts_query = """SELECT COUNT(1) AS num_deleted_posts
FROM `bigquery-public-data.hacker_news.comments`
WHERE deleted = True """728x90
'<Kaggle-Course>' 카테고리의 다른 글
| 캐글 advanced_sql/01-joins-and-unions (0) | 2023.03.15 |
|---|---|
| 캐글 intro_to_sql/02-select-from-where (0) | 2023.03.15 |
| 캐글 intro_to_sql/05-as-with (0) | 2023.03.15 |
| 캐글 intro_to_sql/04-order-by (0) | 2023.03.15 |
| 캐글 intro_to_sql/06-joining-data (0) | 2023.03.15 |