1. सीखें
    2. /
  2. पाठ्यक्रम
    3. /
  3. Introduction to BigQuery
Connected

अभ्यास

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.

निर्देश

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.