# Pastebin wmqXNzdg
SELECT
  normalized_channel AS channel,
  DATE(submission_timestamp) AS date,
  SUM(COALESCE(SAFE_CAST(JSON_EXTRACT_SCALAR(payload.histograms.use_counter2_deprecated_math_ml_deprecated_line_thickness_value_document, '$.sum') AS INT64), 0)) AS total_main_process_counts,
  SUM(COALESCE(SAFE_CAST(JSON_EXTRACT_SCALAR(payload.processes.content.histograms.use_counter2_deprecated_math_ml_deprecated_line_thickness_value_document, '$.sum') AS INT64), 0)) AS total_content_process_counts,
  SUM(payload.processes.content.scalars.mathml_doc_count) AS total_doc_count
FROM
  telemetry.main
WHERE
  DATE(submission_timestamp) >= "2019-08-23"
GROUP BY
  channel,
  date