Thunderbird/Support/Google Big Query Sample SQL queries: Difference between revisions
< Thunderbird | Support
Jump to navigation
Jump to search
(Count All Thunderbird Questions in 2024) |
(→Count All Thunderbird Questions in 2024: show query) |
||
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' ;