 <span class="keyword operator">=</span> <span class="constant numeric">1</span>) / <span class="function call">COUNTIF</span>(color_contrast_score <span class="keyword">IS</span> <span class="keyword">NOT</span> <span class="keyword">NULL</span>) <span class="keyword">AS</span> perc_good_contrast
<span class="keyword">FROM</span> (
  <span class="keyword">SELECT</span>
    client,
    is_root_page,
    <span class="keyword">date</span>,
    <span class="function call">JSON_VALUE</span>(lighthouse, <span cl