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

Exercise

Finding order total value

A common use case for BigQuery is creating analytical reports, such as finding the top 10 results from a query or results within a certain timespan.

For this query, you will find the 10 smallest orders by total cost using the ecommerce.ecomm_payments.

Instructions

100 XP
  • Select the ten smallest orders from the ecommerce.ecomm_payments using SUM on the payment_value column for the first 10 rows of data.