Questions
1) Interstitial + video
2) Native - нету
SELECT date,sum(revenue_per_impression) AS imp, sum(revenue_per_click) AS cl FROM daily_stats WHERE DATE >= '2017-04-01' AND DATE <= '2017-12-10' AND application_id = 2 AND advt_type_id = 2
GROUP BY DATE ORDER BY DATE
advt_types_id
1,"video"
2,"banner"
3,"interstitial"
4,"rewarded"
5,"native"