{
"prompt": "查询最近7天小程序每天支付成功的金额",
"formId": "aigc",
"userId": "bjweidongjun",
"env": "test",
"agent": "1"
}
{
"code": 200,
"data": {
"chartType": 0,
"dataList": [
[
"None"
]
],
"indicatorAliasList": [
"总实付金额"
],
"recommendQuestionList": [
"查询昨天各个支付渠道的总实付金额",
"查询昨天各个商品的总实付金额",
"查询昨天各个订单状态的订单数量"
],
"sql": "SELECT sum(`amount`) as `总实付金额` FROM data_analys.aigc_order WHERE `status` = 2 AND `create_time` >= DATE_SUB(CURDATE(), INTERVAL 1 DAY) AND `create_time` < CURDATE() LIMIT 1000",
"text": null
},
"message": "success"
}