SELECT
count(id)
FROM
user_main
WHERE
delFlag = 0
SELECT
$__timeGroupAlias(createTime, '1h'),
sum(fee) as value
FROM order_pay
GROUP BY 1
ORDER BY 1
SELECT
UNIX_TIMESTAMP(DATE_FORMAT( createTime, "%Y-%m-%d" )) AS time
,
SUM(fee) AS value,
'金额(元)' AS metric
FROM order_pay
WHERE
$__timeFilter(createTime)
group by UNIX_TIMESTAMP(DATE_FORMAT( createTime, "%Y-%m-%d" ))