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.
Este exercício faz parte do curso
Introduction to BigQuery
Instruções do exercício
- 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.
Exercício interativo prático
Experimente este exercício completando este código de exemplo.
-- 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 ___;