SQL Call
DROP TABLE IF EXISTS cars_scott_out;
SELECT * FROM Histogram (
ON cars_hist AS InputTable
OUT TABLE OutputTable (cars_scott_out)
USING
AutoBin ('Scott')
TargetColumn ('hp')
) AS dt;
Output
output_table |
output_columns |
specified in OutputTable argument |
bin bin_start bin_end bin_count bin_percent |
This query returns the following table:
SELECT * FROM cars_scott_out ORDER BY 1;
cars_scott_out
bin |
bin_start |
bin_end |
bin_count |
bin_percent |
0 |
0 |
100 |
9 |
28.13 |
1 |
100 |
200 |
16 |
50.00 |
2 |
200 |
300 |
6 |
18.75 |
3 |
300 |
400 |
1 |
3.13 |