Cộng đồng Hỏi & Đáp của Inflearn

SELECT 
    DATE_TRUNC(CASE 
                   WHEN '${__interval}' = '1s' THEN 'second'
                   WHEN '${__interval}' = '1m' THEN 'minute'
                   WHEN '${__interval}' = '1h' THEN 'hour'
                   WHEN '${__interval}' = '1d' THEN 'day'
                   ELSE 'hour' END, updated_at) AS time,
                   -- query 옵션에서 interval 값보고 조절
    SUM(temperature) AS total_value
FROM 
    environment_data 
WHERE 
    updated_at BETWEEN $__timeFrom() AND $__timeTo()
GROUP BY 
    time
ORDER BY 
    time;