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.
Latihan ini merupakan bagian dari kursus
Introduction to BigQuery
Instruksi latihan
- 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.
Latihan interaktif langsung praktik
Cobalah latihan ini dengan melengkapi kode contoh ini.
-- 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 ___;