+------------+----------+----------------+----------+----------------------+
|     n      |   n_mv   | pct_n_mv_of_n  | n_mv_ni  | pct_n_mv_ni_of_n_mv  |
+------------+----------+----------------+----------+----------------------+
| 656646289  | 4765948  | 0.7258         | 181993   | 3.8186               |
+------------+----------+----------------+----------+----------------------+

select
    n,
    n_mv,
    round(100 * n_mv / n, 4) as pct_n_mv_of_n,
    n_mv_ni,
    round(100 * n_mv_ni / n_mv, 4) as pct_n_mv_ni_of_n_mv
from (
    select
        count(*) as n,
        count(if(uri_query like '%action=mobileview%', 1, null)) as n_mv,
        count(if(uri_query like '%action=mobileview%' and uri_query like '%noimages%', 1, null)) as n_mv_ni
    from
        wmf.webrequest
    where
        year = 2018
        and month = 11
        and day = 28
        and uri_path = '/w/api.php'
) as numbers
;