Thunderbird/Support/Google Big Query Sample SQL queries: Difference between revisions
< Thunderbird | Support
Jump to navigation
Jump to search
(add divs :-)) |
|||
| Line 15: | Line 15: | ||
; | ; | ||
</pre> | </pre> | ||
</div> | |||
== Count All Thunderbird Desktop Questions in 2024 == | == 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"> | ||
| Line 30: | Line 30: | ||
; | ; | ||
</pre> | </pre> | ||
</div> | |||
Revision as of 19:22, 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'
;