select dailysales.entity_id,entities.url,dailysales.price,dailysales.support_price,dailysales.sales,dailysales.comments,dailysales.author,dailysales.stars,entities.created_at,entities.updated_at from dailysales
inner join entities on entities.id = dailysales.entity_id
where entities.created_at > '2018-11-01'
and sales > 10
and tag = 'Start up'
order by sales desc;

select dailysales.entity_id, b.category
from dailysales
inner join (
  select entity_id,json_array_elements(dailysales.categories) category
  from dailysales
) b
on b.entity_id = dailysales.entity_id;

SELECT version();

select count(*) as ttlEntities,
/*dailysales.price,(b.category::text) as category,*/
/*dailysales.price,*/
(b.tag::text) as tag,
round(avg(dailysales.sales)) as avgSales,
round(avg(dailysales.price)) as avgPrice,
sum(dailysales.sales) as sumSales,
sum(dailysales.comments),
sum(dailysales.sales*dailysales.price) as subtotalSold
from dailysales
inner join entities on entities.id = dailysales.entity_id
inner join (
  select entity_id,jsonb_array_elements(dailysales.categories) category ,jsonb_array_elements(dailysales.tags) tag
  from dailysales
) b
on b.entity_id = dailysales.entity_id
where entities.created_at > '2018-11-01'
group by
/*dailysales.price, */
/*category ,*/
tag
having count(*) > 5
order by avgsales desc;

  select dailysales.price, json_array_elements(categories) category
  from dailysales;

select avg(t.price),category::text from (
  select dailysales.price, jsonb_array_elements(categories) category
  from dailysales
) t
group by t.category;

select * from entities where entities.removed = true;