Using COUNTIF
One of the most useful GoogleSQL aggregate functions is COUNTIF which allows you to calculate conditional counts with less code. In this exercise, you will count all the products over a specific weight and group them by category.
Questo esercizio fa parte del corso
Introduction to BigQuery
Istruzioni dell'esercizio
- Write a query that uses the
COUNTIFfunction to find all the products over 5000 grams from theecommerce.ecomm_productstable. - Group the query by the
product_category_name_englishcolumn.
Esercizio pratico interattivo
Prova a risolvere questo esercizio completando il codice di esempio.
-- Complete the query to count all the products over 5000 grams
SELECT
product_category_name_english,
-- Add the function name and conditional expression
___(product_weight_g ___)
FROM ecommerce.ecomm_products
-- Add the correct column for grouping
GROUP BY ___;