do_report_results.sql
This page documents a preview version.
v2.23 Preview
Preview includes features under active development and is for development and testing only.
For production, use the latest stable version (v2024.1).
For production, use the latest stable version (v2024.1).
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