SQL

-- rewarded

SELECT date, sum(clicks) as ad_rewarded_click, sum(impressions) as ad_rewarded_impressions FROM daily_stats 

WHERE 

DATE BETWEEN '2017-09-01' AND '2017-11-28'

and application_id = 3 

and advt_type_id = 4 

group by date order by date asc

-- banner

SELECT date, sum(clicks) as ad_banner_click, sum(impressions) as ad_banner_impressions FROM daily_stats 

WHERE 

DATE BETWEEN '2017-09-01' AND '2017-11-28'

and application_id = 3 

and advt_type_id = 2

group by date order by date asc

-- interstitital

SELECT date, sum(clicks) as ad_interstitial_click, sum(impressions) as ad_interstitial_click

FROM daily_stats 

WHERE 

DATE BETWEEN '2017-09-01' AND '2017-11-28'

and application_id = 3 

and advt_type_id = 3 

group by date order by date asc

-- получение когорты (Install)

SELECT install_date, count(*) FROM sources 

WHERE application_id=3 

AND install_date 

BETWEEN '2017-09-01' AND '2017-11-29'

GROUP BY install_date