728x90
joining-data
-
캐글 intro_to_sql/06-joining-data<Kaggle-Course> 2023. 3. 15. 15:26
questions_query = \ """ SELECT id, title, owner_user_id FROM `bigquery-public-data.stackoverflow.posts_questions` WHERE tags LIKE '%bigquery%' """ answers_query = \ """ SELECT pa.id, pa.body, pa.owner_user_id FROM `bigquery-public-data.stackoverflow.posts_questions` AS pq INNER JOIN `bigquery-public-data.stackoverflow.posts_answers` AS pa ON pq.id = pa.parent_id WHERE pq.tags LIKE '%bigquery%' "..