S</span> total_applicable,
  <span class="function call">COUNTIF</span>(<span class="function call">CAST</span>(color_contrast_score <span class="keyword">AS</span> <span class="keyword">NUMERIC</span>) <span class="keyword operator">=</span> <span class="constant numeric">1</span>) <span class="keyword">AS</span> total_good_contrast,
  <span class="function call">COUNTIF</span>(<span class="function call">CAST</span>(color_contrast_score <span class="keyword">AS</span> <span class="keyword">NUMERIC</span>)