Skip to content

Instantly share code, notes, and snippets.

@jamiekt
Created July 17, 2018 08:13
Show Gist options
  • Select an option

  • Save jamiekt/be0c85c009c4b0733f8991d837649b34 to your computer and use it in GitHub Desktop.

Select an option

Save jamiekt/be0c85c009c4b0733f8991d837649b34 to your computer and use it in GitHub Desktop.
select count(distinct basket) as number_of_baskets_purchased
, count(distinct product) as number_of_products_purchased
, count(distinct customer) as number_of_customers_purchasing
, count(distinct store) as number_of_stores_purchased_in
from data
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment