test

0

Please login or register to vote for this query.

(click on this box to dismiss)

The Workplace Meta

Q&A about the site for members of the workforce navigating the professional setting

SELECT
    bin_floor,
    CONCAT(bin_floor, ' to ', bin_ceiling) AS views_count,
    COUNT(*) AS cnt
FROM (
	SELECT 
		FLOOR(Views / 10.00) * 10 AS bin_floor,
		FLOOR(Views / 10.00) * 10 + 10 AS bin_ceiling
	FROM Users
) temp
GROUP BY CONCAT(bin_floor, ' to ', bin_ceiling), bin_floor
ORDER BY bin_floor;

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results