Exercise

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.

Instructions

100 XP

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.

.css-6su6fj{-webkit-flex-shrink:0;-ms-flex-negative:0;flex-shrink:0;}Exercise

Instructions

Exercise