Follow
どのカードが(今月で)一番高値で売れるか調べてるところ
SELECT item_name, AVG(unit_cost/1000000000) AS '単価(Gzeny)'
FROM item_detail_tbl
WHERE item_name LIKE '%カード'
AND `datetime` BETWEEN '2019-04-01' AND '2019-04-31'
GROUP BY item_name
ORDER BY 2 DESC
LIMIT 20
;
