SQL聚合event数据按天统计

SELECT SUM(price), 'event', DATE(FROM_UNIXTIME(create_time)) AS date FROM vp_user_inventory_history ih JOIN vp_user_inventory_history_item hi ON ih.id = hi.history_id GROUP BY date, 'event';