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.
Cet exercice fait partie du cours
Introduction to BigQuery
Instructions
- 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.
Exercice interactif pratique
Essayez cet exercice en complétant cet exemple de code.
-- 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 ___;