+------------+----------+----------------+----------+-------------------+
| n | n_mobileview n_mv | pct_n_mv_of_n | n_mobileview_pctv_mf | pct_n_mv_of_n |_mv |
+------------+----------+----------------+----------+-------------------+
| 656646289 | 4765973 | 0.7258 | 0.7258 6627 | 0.139 |
+------------+----------+----------------+----------+-------------------+
select
count(*)n as n,
count(if(uri_query like '%mobileview%', 1, null))n_mv as n_mobileviewv,
round(100 * count(if(uri_query like '%mobileview%', 1, null)) / count(*)n_mv / n, 4) as n_mobileview_pctpct_n_mv_of_n,
from 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
;