Aug 21, 2020
Below are some simple example queries to get you started with the Headset data model.
Revenue, units, and profit for each store in June 2020
select
store_name,
sum(revenue) as revenue,
sum(quantity) as units,
sum(profit) as profit
from headset.retail_share.sales
where sold_date between '2020-06-01' and '2020-07-01'
group by 1;
Top 10 products by unit sales on 8/2/2020
select
product_name,
sum(quantity)
from headset.retail_share.sales
where sold_date between '2020-08-02' and '2020-08-03'
group by 1
order by 2 desc
limit 10;
Brands that have had the most cartridge returns in 2020
select
brand,
vendor,
sum(quantity) as returned_units
from headset.retail_share.sales
where
receipt_type='REFUND'
and category in ('Cartridge','Cartridges')
and date_part(year,sold_date)=2020
group by 1,2
order by 3;
Current inventory by category
select
category,
sum(quantity_in_stock) as quantity_in_stock
from headset.retail_share.products
group by 1
order by 2 desc;