1. Learn
    2. /
  2. Courses
    3. /
  3. Introduction to BigQuery
Connected

Exercise

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.

Instructions

100 XP
  • Complete the query by using the ANY_VALUE aggregate function on the product_category_name_english column, including the HAVING clause to find the maximum value of product_photos_qty, and assign the alias random_product to the result.