Explore this snippet with some demo data here.
Creating histograms using SQL can be tricky. This snippet will let you quickly create the bins needed to create a histogram:
SELECT COUNT(1) / (SELECT COUNT(1) FROM '<table>' ) percentage_of_results FLOOR(<column>/ <bin-size>) * <bin-size> as bin FROM '<table>' GROUP BY bin
<column>is the column to turn into a histogram
<bin-size>is the width of each bin. You can adjust this to get the desired level of detail for the histogram.
To use, adjust the bin-size until you can see the ‘shape’ of the data. The following example finds the percentage of days in London by 5-degree temperature groupings.
SELECT count(*) / (select count(1) from PUBLIC.LONDON_WEATHER) percentage_of_results, floor(LONDON_WEATHER.TEMP / 5) * 5 bin from PUBLIC.LONDON_WEATHER group by bin order by bin