text: #standardSQL
  
  -- Copyright 2018 Google LLC
  --
  -- Licensed under the Apache License, Version 2.0 (the "License");
  -- you may not use this file except in compliance with the License.
  -- You may obtain a copy of the License at
  --
  --     https://www.apache.org/licenses/LICENSE-2.0
  --
  -- Unless required by applicable law or agreed to in writing, software
  -- distributed under the License is distributed on an "AS IS" BASIS,
  -- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
  -- See the License for the specific language governing permissions and
  -- limitations under the License.
  
  -- This example is using the Google analytics sample data set
  -- This script calculates the total transactions per device for a given date range
  
  SELECT
  (SUM (total_transactions_per_user) / COUNT(fullVisitorId) ) AS avg_total_transactions_per_user
  FROM (
  SELECT
  fullVisitorId,
  SUM (totals.transactions) AS total_transactions_per_user
  FROM
  `bigquery-public-data.google_analytics_sample.ga_sessions_*`
  WHERE
  _TABLE_SUFFIX BETWEEN '20170701' AND '20170731'
  AND totals.transactions IS NOT NULL
  GROUP BY
  fullVisitorId )
  