Count data using multiple date ranges
select  industry_id
,       sum(case when current_date &lt;= date then clicks end) as today 
,       sum(case when current_date-1 &lt;= date and
                      date &lt; current_date then clicks end) as yesterday
,       sum(case when current_date-4 &lt;= date and 
                      date &lt; current_date-1 then clicks end) as last3days
from    phone_clicks
group by
        industry_id


See it in your SQLFiddle.