Thunderbird/Support/Google Big Query Sample SQL queries

Count All Solved Android Desktop Questions in 2024

• staff only link to BQ query
• results (4% solved):

tb_android_2024_aaq,solved_tb_android_2024
311,12

SELECT
  COUNT(*) as tb_android_2024_aaq, COUNTIF(is_solved is true) AS solved_tb_android_2024
FROM
  moz-fx-data-sumo-prod.mzla.metrics_thunderbird_questions
WHERE
  EXTRACT(YEAR
  FROM
    DATETIME(created_utc)) = 2024
  AND product LIKE 'thunderbird-android'
;

Count All Solved Thunderbird Desktop Questions in 2024

• staff only link to BQ query
• results (13% solved):

tb_desktop_2024_aaq,solved_tb_desktop_2024
15506,1970

SELECT
  COUNT(*) as tb_desktop_2024_aaq, COUNTIF(is_solved is true) AS solved_tb_desktop_2024
FROM
  moz-fx-data-sumo-prod.mzla.metrics_thunderbird_questions
WHERE
  EXTRACT(YEAR
  FROM
    DATETIME(created_utc)) = 2024
  AND product LIKE 'thunderbird'
;

Count All Thunderbird Desktop Questions in 2024

SELECT
  COUNT (*)
FROM
  moz-fx-data-sumo-prod.mzla.metrics_thunderbird_questions
WHERE
  EXTRACT(YEAR
  FROM
    DATETIME(created_utc)) = 2024
  AND product LIKE 'thunderbird'
;