#standardSQL

# This query will get the average and standard deviation of a "score" parameter that's part of a
# "round_completed" event. Feel free to replace these values to match events and parameters that are
# already in your app.

SELECT
  AVG(param.value.int_value) AS avg_score,
  stddev(param.value.int_value) AS stddev
FROM
 `<dataset>.events_<date>`,
  UNNEST(event_params) AS param
WHERE
  event_name = "round_completed"
  AND param.key = "score"