Thunderbird/Support/Google Big Query Sample SQL queries: Difference between revisions

From MozillaWiki
Jump to navigation Jump to search
Line 1: Line 1:
__TOC__
__TOC__
== Count All Thunderbird Questions in 2024 ==
== Count All Solved Thunderbird Desktop Questions in 2024 ==
* [staff only link to BQ query https://console.cloud.google.com/bigquery?ws=!1m7!1m6!12m5!1m3!1smoz-fx-data-sumo-prod!2snorthamerica-northeast1!3s3adc7726-d692-4123-8a42-50042d481727!2e1]
<div class="mw-collapsible mw-collapsed" data-expandtext="show query">
<pre>
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'
;
</pre>
== Count All Thunderbird Desktop Questions in 2024 ==
<div class="mw-collapsible mw-collapsed" data-expandtext="show query">
<div class="mw-collapsible mw-collapsed" data-expandtext="show query">
<pre>
<pre>

Revision as of 19:20, 28 May 2025

Count All Solved Thunderbird Desktop Questions in 2024

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'
;
Retrieved from "https://wiki.mozilla.org/index.php?title=Thunderbird/Support/Google_Big_Query_Sample_SQL_queries&oldid=1254235"