Calculating the MODE in BigQuery

How do you compute the MODE (most frequent value) in BigQuery? For the other measures of central tendency like MEAN and MEDIAN, there are straightforward ways to compute results - functions AVG and PERCENTILE_CONT/PERCENTILE_DIST respectively, but th...