You are working with a large dataset in BigQuery gcp video

 ·  PT1H46M27S  ·  EN

data-practitioner video for you are working with a large dataset in BigQuery called web_traffic , which includes fields for user_id , visit_date , page_views ,

Full Certification Question

You are working with a large dataset in BigQuery called web_traffic , which includes fields for user_id , visit_date , page_views , and session_duration . To identify patterns in user engagement, you want to find the average session duration for users who visited the site more than 5 times in the past month. Which SQL query best accomplishes this?