-- TABLE T1
-- count the number of unique ip addresses 
-- that connect to the webserver for each day

SELECT log_date,count(ip_addr) AS "visits"
INTO TEMP TABLE T1
FROM (
        SELECT DISTINCT ON(log_date,ip_addr)
        log_date,ip_addr FROM http_log
      ) AS http_counter_tmp      
GROUP BY log_date
ORDER BY log_date DESC;

-- TABLE T2
-- show the number of downloads 
-- for the SRAA whitepaper for each day
SELECT log_date,count(ip_addr) AS "SRAA Whitepaper"
INTO TEMP TABLE T2
FROM (
        SELECT DISTINCT ON (log_date, ip_addr) log_date, ip_addr
        FROM http_log
        WHERE record ~ '.pdf' AND record ~ 'SRAA'
      ) AS http_counter_tmp
GROUP BY log_date
ORDER BY log_date DESC;

-- TABLE T3
-- show the number of downloads 
-- for the Informix whitepaper for each day
SELECT log_date,count(ip_addr) AS "Informix Whitepaper"
INTO TEMP TABLE T3
FROM (
        SELECT DISTINCT ON (log_date, ip_addr) log_date, ip_addr
        FROM http_log
        WHERE record ~ '.pdf' AND record ~ 'informix'
      ) AS http_counter_tmp
GROUP BY log_date
ORDER BY log_date DESC;