
        SELECT 
            location AS label,
            ROUND(SUM(net_tv_india + net_ott_india + net_tv_ott_row + print + social)/10000000, 2) AS net_total
        FROM cricket_data
        WHERE user_group= 2
     AND brand = :brand AND match_date >= :start_date AND match_date <= :end_date GROUP BY location ORDER BY net_total DESC