do_report_results.sql

This page documents the preview version (v2.21). Preview includes features under active development and is for development and testing only. For production, use the stable version (v2024.1). To learn more, see Versioning.

Save this script as do_report_results.sql.

\t on
select 'Using ntile().';
\t off

select
  bucket,
  n,
  to_char(min_s, '990.99999') as min_s,
  to_char(max_s, '990.99999') as max_s
from results
where method = 'ntile'
order by bucket;

\t on
select 'Using percent_rank().';
select
  bucket,
  n,
  to_char(min_s, '990.99999') as min_s,
  to_char(max_s, '990.99999') as max_s
from results
where method = 'percent_rank'
order by bucket;

select 'Using cume_dist().';
select
  bucket,
  n,
  to_char(min_s, '990.99999') as min_s,
  to_char(max_s, '990.99999') as max_s
from results
where method = 'cume_dist'
order by bucket;
\t off