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.

Deze oefening maakt deel uit van de cursus

Introduction to BigQuery

Cursus bekijken

Oefeninstructies

Write a query that uses the COUNTIF function to find all the products over 5000 grams from the ecommerce.ecomm_products table.
Group the query by the product_category_name_english column.

Praktische interactieve oefening

Probeer deze oefening eens door deze voorbeeldcode in te vullen.

-- 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 ___;

Code bewerken en uitvoeren