title: SQL query for Google BigQuery to count Sessions and Pageviews
body: <p>I am using Google Big Query to query the daily Google analytics reports for my website. I am running queries on 7 tables (the 7 daily reports) at a time, because I want to use weekly results. </p>
  
  <p>I would like to run a query that shows "<code>Users with &gt;= x sessions and with &gt;= y page views</code>". I am having difficulties framing this query.</p>
  
  <p>The resulting table should show the fullVisitorId, totals.visits (The number of sessions), totals.pageviews (Total number of pageviews within the session). Should I use a subquery, or is there some other method?</p>
  
  <p>Please use the following link if you'd like to have a look at the complete scheme: <a href="https://support.google.com/analytics/answer/3437719?hl=en" rel="nofollow">https://support.google.com/analytics/answer/3437719?hl=en</a></p>