Page History

select  to_char(month, 'YYYY') as year, to_char(sum(delivered/1024^4), 'FM999,999,999,990') as "delivered" from datasets_stats_monthly where dataset='tigge-global' and month>=date'2015-01-01'  group by year order by year ;
select  to_char(month, 'YYYY') as year, to_char(sum(retrieved/1024^4), 'FM999,999,999,990') as "retrieved" from datasets_stats_monthly where dataset='tigge-global' and month>=date'2015-01-01' group by year order by year

select  to_char(month, 'YYYY') as year, to_char(sum(delivered/1024^4), 'FM999,999,999,990') as "delivered" from datasets_stats_monthly where dataset='tigge-global' and month>=date'2015-01-01'  group by year order by year ;

select  to_char(month, 'YYYY') as year, sum(requests) as "user requests" from datasets_stats_monthly where dataset='tigge-global' and month>=date'2015-01-01'  group by year order by year ;

SELECT to_char(month, 'YYYY') as year, count(DISTINCT username) as "active users"
FROM  users_stats_monthly 
WHERE dataset='tigge-global' AND month>=date'2015-01-01' 
AND username IN (
      SELECT username                        
      FROM  users_stats_monthly
      WHERE dataset='tigge-global'
      GROUP BY username
      HAVING sum(requests) >= 1
      )
GROUP BY year
ORDER BY year;