psql -d news -f newsdata.sql

create view path_view as 
        select path, count(*) as num from log where 
        path like '/article/%' 
        group BY path  
        order BY num desc;

create view author_view as 
        select articles.title as title, 
        articles.author as author, 
        path_view.num as num 
        from articles join path_view 
        on path_view.path = concat('/article/', articles.slug) 
        order by path_view.num desc;

create view error_view as 
       select date(time) as day, count (*) as num
       from log 
       where status like '404%' 
       group by day;

 create view total_view as 
       select date(time) as day, count(*) as num
       from log 
       group by day;

python log_analysis.py 1

Candidate is jerk, alleges rival -- 338647
Bears love berries, alleges bear -- 253801
Bad things gone, say good people -- 170098

python log_analysis.py 2

Ursula La Multa -- 507594
Rudolf von Treppenwitz -- 423457
Anonymous Contributor -- 170098
Markoff Chaney -- 84557

python log_analysis.py 3

This will list all the days which has more than 1% request errors 

Jul 17, 2016 -- 2.26% errors