Tables in the wild
You're working for an e-commerce company amidst a pivotal moment of transition. Your company is migrating its data infrastructure from Postgres to BigQuery, aiming for enhanced scalability and efficiency. Your manager has a crucial task for you: to identify the unique seller cities within the dataset.
Diese Übung ist Teil des Kurses
Introduction to BigQuery
Anleitung zur Übung
- Modify the code to select the distinct
seller_cityvalues from theecomm_sellerstable in theecommercedataset.
Interaktive Übung
Vervollständige den Beispielcode, um diese Übung erfolgreich abzuschließen.
SELECT DISTINCT seller_city
-- Specify the dataset and table
FROM ____;