+------------+----------+----------------+----------+-------------------+ | n | n_mv | pct_n_mv_of_n | n_mv_mf | pct_n_mv_of_n_mv | +------------+----------+----------------+----------+-------------------+ | 656646289 | 4765973 | 0.7258 | 6627 | 0.139 | +------------+----------+----------------+----------+-------------------+ select n as n, n_mv as n_mv, round(100 * n_mv / n, 4) as pct_n_mv_of_n, n_mv_mf as n_mv_mf, round(100 * n_mv_mf / n_mv, 4) as pct_n_mv_of_n_mv from ( select count(*) as n, count(if(uri_query like '%mobileview%', 1, null)) as n_mv, count(if(uri_query like '%mobileview%' and uri_query like '%mobileformat%', 1, null)) as n_mv_mf from wmf.webrequest where year = 2018 and month = 11 and day = 28 and uri_path = '/w/api.php' ) as numbers ;