RODBさんが元気になったので、活用 B鯖過去1日分のDV平均価格
SELECT item_name AS 'アイテム名' ,
(SUM(cost) / SUM(count)) AS '平均価格',
SUM(count) AS '件数'
FROM item_detail_tbl
WHERE item_name LIKE 'ディーヴァ%' AND
datetime > (NOW() - INTERVAL 1 DAY) AND
world LIKE 'Breidablik' AND
smelting LIKE 0
GROUP BY item_name
ORDER BY `件数` DESC;