-- Requests Total
select count(*),virtual_domain from log_entries group by virtual_domain;

-- Requests per Day
select count(*),request_time::date,virtual_domain from log_entries group by virtual_domain,request_time::date;

-- Unique Hits
select count(distinct (remote_host)),virtual_domain from log_entries group by virtual_domain;

-- Unique Hits per Day
select count(distinct (remote_host)),request_time::date,virtual_domain from log_entries group by virtual_domain,request_time::date;
