tencent cloud

compare (x, n)

compare (x, n1, n2, n3...)

* | SELECT compare(PV, 86400) FROM (SELECT count(*) AS PV)

[1860,1656,1.1231884057971016]

* | 
SELECT compare[1] AS today, compare[2] AS yesterday, compare[3] AS ratio
FROM (
    SELECT compare(PV, 86400) AS compare
    FROM (
        SELECT COUNT(*) AS PV
    )
)

* | 
select concat(cast(current_date as varchar),' ',time) as time,compare[1] as today,compare[2] as yesterday from (
    select time,compare(pv, 86400) as compare from (
        select time_series(__TIMESTAMP__, '5m', '%H:%i:%s', '0')  as time, count(*) as pv group by time limit 1000) 
    limit 1000)
order by time limit 1000