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

From MozillaWiki
Jump to navigation Jump to search
(Count All Thunderbird Questions in 2024)
 
Line 1: Line 1:
__TOC__
== Count All Thunderbird Questions in 2024 ==
== Count All Thunderbird Questions in 2024 ==
<div class="mw-collapsible mw-collapsed" data-expandtext="show query">
<pre>
<pre>
SELECT
SELECT

Revision as of 19:18, 28 May 2025

Count All Thunderbird 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'
;