base/tracing/test/trace_processor/diff_tests/chrome/chrome_speedometer_test.sql

-- Copyright 2023 The Chromium Authors
-- Use of this source code is governed by a BSD-style license that can be
-- found in the LICENSE file.

INCLUDE PERFETTO MODULE chrome.speedometer;

SELECT
  iteration,
  ts,
  dur,
  total,
  format('%.1f', mean) AS mean,
  format('%.1f', geomean) AS geomean,
  format('%.1f', score) AS score,
  num_measurements
FROM
  chrome_speedometer_iteration,
  (
    SELECT iteration, COUNT(*) AS num_measurements
    FROM chrome_speedometer_measure
    GROUP BY iteration
  )
USING (iteration)
ORDER BY iteration;