output table | output columns |
---|---|
"cars_hist_out" | cyl bin bin_start bin_end bin_count bin_percent |
The following query returns the output shown in the following table:
SELECT * FROM cars_hist_out ORDER BY 1;
cyl | bin | bin_start | bin_end | bin_count | bin_percent |
---|---|---|---|---|---|
4 | 0 | 20 | 70 | 5 | 45.45 |
4 | 1 | 70 | 120 | 6 | 54.55 |
4 | 2 | 120 | 170 | 0 | 0.00 |
4 | 3 | 170 | 220 | 0 | 0.00 |
4 | 4 | 220 | 270 | 0 | 0.00 |
4 | 5 | 270 | 320 | 0 | 0.00 |
4 | 6 | 320 | 370 | 0 | 0.00 |
4 | 7 | 370 | 400 | 0 | 0.00 |
6 | 0 | 20 | 70 | 0 | 0.00 |
6 | 1 | 70 | 120 | 4 | 57.14 |
6 | 2 | 120 | 170 | 2 | 28.57 |
6 | 3 | 170 | 220 | 1 | 14.29 |
6 | 4 | 220 | 270 | 0 | 0.00 |
6 | 5 | 270 | 320 | 0 | 0.00 |
6 | 6 | 320 | 370 | 0 | 0.00 |
6 | 7 | 370 | 400 | 0 | 0.00 |
8 | 0 | 20 | 70 | 0 | 0.00 |
8 | 1 | 70 | 120 | 0 | 0.00 |
8 | 2 | 120 | 170 | 2 | 14.29 |
8 | 3 | 170 | 220 | 7 | 50.00 |
8 | 4 | 220 | 270 | 4 | 28.57 |
8 | 5 | 270 | 320 | 0 | 0.00 |
8 | 6 | 320 | 370 | 1 | 7.14 |
8 | 7 | 370 | 400 | 0 | 0.00 |