0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for Drupal developers and administrators

WITH ViewBins AS (
    SELECT 
        FLOOR(ViewCount / 1000) * 1000 AS ViewBin
    FROM 
        Posts
    WHERE 
        PostTypeId = 1  -- 1은 질문을 나타냅니다
)
SELECT 
    ViewBin,
    COUNT(*) AS Frequency
FROM 
    ViewBins
GROUP BY 
    ViewBin
ORDER BY 
    ViewBin

fork query

edited sep 7

created sep 7 anonymous