Histogram Example 1: AutoBin ('Sturges') - Teradata Vantage

Input

The InputTable, cars_hist, has the cylinder (cyl) and horsepower (hp) data for different car models. The examples compute the histograms on the hp column.

SQL Call

DROP TABLE IF EXISTS cars_sturges_out;

SELECT * FROM Histogram (
  ON cars_hist AS InputTable
  OUT TABLE OutputTable (cars_sturges_out)
  USING
  AutoBin ('Sturges')
  TargetColumn ('hp')
) AS dt;

Output

This query returns the following table:

SELECT * FROM cars_sturges_out ORDER BY 1;