Follow

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;

· · Web · 0 · 3 · 4
Sign in to participate in the conversation
RO丼 - RO Mastodon

ラグナロクオンラインユーザ向けのMastodonインスタンス。