sql

# ADVERTISER REPORT
explain SELECT
report_etl.advertiser_name AS "Advertiser",
SUM(report_etl.target_base) AS "Audience",
SUM(report_etl.active_sim_card) AS "Actives",
SUM(report_etl.targeted) AS "Deliviered",
SUM(report_etl.accepted) AS "Acceptances",
#( targeted / IF( sent < active_sim_card, sent, active_sim_card))  AS "DLV" ,
#( active_sim_card / sent_ping ) AS "Active",
(
	SUM(accepted) / IF(
		SUM(active_sim_card) < 1, IF(
			SUM(report_etl.target_base) > SUM(report_etl.sent), SUM(report_etl.sent), SUM(report_etl.active_sim_card)
		),
		SUM(active_sim_card)
	)
) AS "CR",
( SUM(accepted) / SUM(targeted) ) AS "AR",
SUM(report_etl.revenue)  AS "Revenue"
FROM report_etl
WHERE report_etl.account_id = 27 AND report_etl.`_datetime` >= "2019-08-01 00:00:00"
GROUP BY advertiser_name ASC
WITH ROLLUP