下面这个SQL我想变成按天聚合event数据select sumpriceeventFROM_UNIXTIMEcreate_time Ymd as date from vp_user_inventory_history ih join vp_user_inventory_history_item hi on ihid =hihistory_id group by dateevent;

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;