Page History

select  to_char(month, 'MM/YYYY') as monthyear, CAST(delivered AS FLOAT)/1024^4 as "data volume" from datasets_stats_monthly where dataset='uerra' and month>=date'2017010120160101' order by month

select  to_char(month, 'MM/YYYY') as monthyear, requests from datasets_stats_monthly where dataset='uerra' and month>=date'2017010120160101' order by month;

select  to_char(month, 'MM/YYYY') as monthyear, fields from datasets_stats_monthly where dataset='uerra' and month>=date'2017010120160101' order by month

SELECT to_char(month, 'MM/YYYY') as monthyear, count(DISTINCT username)as "active users"
FROM  users_stats_monthly 
WHERE dataset='uerra' AND month>=date'2017010120160101' 
AND username IN (
      SELECT username                        
      FROM  users_stats_monthly
      WHERE dataset='uerra'
      GROUP BY username
      HAVING sum(requests) >= 3
      )
GROUP BY month
ORDER BY month;

SELECT profile_country.name, count(DISTINCT auth_user.username) as total_users
    FROM  profile_country
         RIGHT JOIN profile_profile ON profile_profile.country_id = profile_country.id
         RIGHT JOIN auth_user ON auth_user.id = profile_profile.user_id
         RIGHT JOIN users_stats_monthly ON users_stats_monthly.username = auth_user.username
    WHERE users_stats_monthly.dataset='uerra' and users_stats_monthly.month>=date'2017010120160101'
GROUP BY profile_country.name
ORDER BY total_users DESC;