質問編集履歴
1
解決
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -73,3 +73,19 @@
|
|
|
73
73
|
・
|
|
74
74
|
|
|
75
75
|
よろしくお願いします。
|
|
76
|
+
|
|
77
|
+
|
|
78
|
+
|
|
79
|
+
回答を見て、
|
|
80
|
+
|
|
81
|
+
SELECT
|
|
82
|
+
|
|
83
|
+
item_code,sum(order_count) AS order_count
|
|
84
|
+
|
|
85
|
+
FROM order_history
|
|
86
|
+
|
|
87
|
+
WHERE status='3'
|
|
88
|
+
|
|
89
|
+
GROUP BY item_code
|
|
90
|
+
|
|
91
|
+
ORDER BY order_count desc LIMIT 10 と記述したところ思いとおりの動きをしました
|