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"