Unsold Inventory¶
The public dataset bigquery-public-data.thelook_ecommerce contains fictitious ecommerce data like
-
distribution_centers
-
inventory_items
Determine the value (cost of goods) of unsold inventory for each distribution center. Sort the results from high to low.
Expected Result
View the data while you write the query
BigQuery Console's split tab view lets you see your data as you write in the editor. You can open a table in a split pane with
- Cmd+Shift (Mac OS) or
- Ctrl+Shift (Windows) or
- Right click > Move tab to left/right pane
Where is the thelook_ecommerce dataset?
- Search for "bigquery-public-data"
- Pin the project
- Clear the search
- Expand the bigquery-public-data project and you should see thelook_ecommerce dataset.