do_report_results.sql
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