ANY_VALUE
One of the new functions you learned that is specific to GoogleSQL is the ANY_VALUE aggregate that allows you to return a value from a text column. You can use this in combination with HAVING to find a maximum or minimum value. This allows us to have some flexibility to return a single value when aggregating across a large dataset.
Cet exercice fait partie du cours
Introduction to BigQuery
Instructions
- Complete the query by using the
ANY_VALUEaggregate function on theproduct_category_name_englishcolumn, including theHAVINGclause to find the maximum value ofproduct_photos_qty, and assign the aliasrandom_productto the result.
Exercice interactif pratique
Essayez cet exercice en complétant cet exemple de code.
-- Finish the query below by adding the ANY_VALUE function
SELECT
product_weight_g,
-- Complete the query by adding the ANY_VALUE function on the product category column
___
FROM ecommerce.ecomm_products
GROUP BY product_weight_g;