ass="string">'$.audits.color-contrast.score'</span>) <span class="keyword">AS</span> color_contrast_score
  <span class="keyword">FROM</span>
    <span class="string">`httparchive.all.pages`</span>
  <span class="keyword">WHERE</span>
    <span class="keyword">date</span> <span class="keyword operator">=</span> <span class="string">'2024-06-01'</span>
)
<span class="keyword">GROUP</span> <span class="keyword">BY</span>
  client,
  is_root_page,
  <span class="keyword">date</span>
<span class="keyword">ORDER