-
캐글 intro_to_sql/03-group-by-having-count<Kaggle-Course> 2023. 3. 15. 15:37728x90
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