google-bigquerygoogle-cloudsql

Unsold Inventory

Ben Gorman

Ben Gorman

Life's a garden. Dig it.

Challenge

The public dataset bigquery-public-data.thelook_ecommerce contains fictitious ecommerce data like

  • distribution_centers

    distcenters

  • inventory_items

    inventory

Determine the value (cost of goods) of unsold inventory for each distribution center. Sort the results from high to low.

Expected Result

unsold

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

  • ++command+shift++ :material-plus::material-cursor-default-outline: (Mac OS) or
  • ++ctrl+shift++ :material-plus::material-cursor-default-outline: (Windows) or
  • Right click > Move tab to left/right pane

split-tabs

Where is the thelook_ecommerce dataset?

  1. Search for "bigquery-public-data"
  2. Pin the project
  3. Clear the search
  4. Expand the bigquery-public-data project and you should see thelook_ecommerce dataset.

See here for details.

Solution 1

This content is gated

Subscribe to one of the products below to gain access

Solution 2

This content is gated

Subscribe to one of the products below to gain access