Challenge: Analyzing Top Products
Pyyhkäise näyttääksesi valikon
Modern Practice
In the video and course examples, you will see the JSON_EXTRACT function. While this function is fully supported and works correctly, it is considered legacy syntax in BigQuery.
For your own future projects, we recommend using the modern standard functions:
JSON_VALUE: extracts scalar values (like strings or numbers) and removes extra quotes automatically;JSON_QUERY: extracts complex JSON objects or arrays.
Write a query that shows sales analysis for our top products using the data in our retail_data_updated table:
- Extract product names from the JSON in the
'products'column; - Count how many times each product appears in transactions;
- Calculate the total revenue generated by each product;
- Group results by product name;
- Sort by the most frequently purchased products.
Your query should return these columns:
'product_name'(extracted from JSON);'purchase_count'(how many times this product appears);'total_revenue'(sum of transaction amounts where this product appears).
Oliko kaikki selvää?
Kiitos palautteestasi!
Osio 2. Luku 2
Kysy tekoälyä
Kysy tekoälyä
Kysy mitä tahansa tai kokeile jotakin ehdotetuista kysymyksistä aloittaaksesi keskustelumme
Osio 2. Luku 2
