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