This is a dedicated watch page for a single video.
Scenario: You are migrating a table to BigQuery and considering the data model. The table contains data on purchases made at various store locations, including transaction time, items purchased, store ID, and store location details like city and state. You frequently query this table to see how many of each item were sold over the past 30 days and to look at purchasing trends by state, city, and individual store. Question: How should you structure the table to optimize query performance for analyzing item sales and purchasing trends by state, city, and individual store in BigQuery?