質問編集履歴
5
コード修正
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -74,7 +74,7 @@
|
|
|
74
74
|
|
|
75
75
|
SUM(salesamt2 + discount3) AS 売上,
|
|
76
76
|
|
|
77
|
-
|
|
77
|
+
CASE salesstore WHEN '9999' THEN 'EC' ELSE '店舗' END AS チャネル
|
|
78
78
|
|
|
79
79
|
FROM saleswithcustomers
|
|
80
80
|
|
4
コードに修正
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -14,6 +14,8 @@
|
|
|
14
14
|
|
|
15
15
|
■テーブル
|
|
16
16
|
|
|
17
|
+
```
|
|
18
|
+
|
|
17
19
|
kaiinno salesstore SKU salesamt2 discount3
|
|
18
20
|
|
|
19
21
|
１ 9999 みかん 100 50
|
|
@@ -27,6 +29,8 @@
|
|
|
27
29
|
４ 9999 すいか 600 10
|
|
28
30
|
|
|
29
31
|
|
|
32
|
+
|
|
33
|
+
```
|
|
30
34
|
|
|
31
35
|
※9999のみECでその他は店舗での購入としたい
|
|
32
36
|
|
3
文字の修正
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -16,15 +16,15 @@
|
|
|
16
16
|
|
|
17
17
|
kaiinno salesstore SKU salesamt2 discount3
|
|
18
18
|
|
|
19
|
-
１
|
|
19
|
+
１ 9999 みかん 100 50
|
|
20
20
|
|
|
21
|
-
２
|
|
21
|
+
２ 1111 みかん 100 50
|
|
22
22
|
|
|
23
|
-
３
|
|
23
|
+
３ 2222 りんご 300 30
|
|
24
24
|
|
|
25
|
-
４
|
|
25
|
+
４ 3333 すいか 600 0
|
|
26
26
|
|
|
27
|
-
４
|
|
27
|
+
４ 9999 すいか 600 10
|
|
28
28
|
|
|
29
29
|
|
|
30
30
|
|
2
テーブルとコードを修正
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -14,17 +14,17 @@
|
|
|
14
14
|
|
|
15
15
|
■テーブル
|
|
16
16
|
|
|
17
|
-
|
|
17
|
+
kaiinno salesstore SKU salesamt2 discount3
|
|
18
18
|
|
|
19
|
-
１ ９９９９ みかん 100
|
|
19
|
+
１ ９９９９ みかん 100 50
|
|
20
20
|
|
|
21
|
-
２ １１１１ みかん 100
|
|
21
|
+
２ １１１１ みかん 100 50
|
|
22
22
|
|
|
23
|
-
３ ２２２２ りんご 300
|
|
23
|
+
３ ２２２２ りんご 300 30
|
|
24
24
|
|
|
25
|
-
４ ３３３３ すいか 600
|
|
25
|
+
４ ３３３３ すいか 600 0
|
|
26
26
|
|
|
27
|
-
４ ９９９９ すいか 600
|
|
27
|
+
４ ９９９９ すいか 600 10
|
|
28
28
|
|
|
29
29
|
|
|
30
30
|
|
1
文字修正
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -24,13 +24,13 @@
|
|
|
24
24
|
|
|
25
25
|
４ ３３３３ すいか 600
|
|
26
26
|
|
|
27
|
-
４
|
|
27
|
+
４ ９９９９ すいか 600
|
|
28
28
|
|
|
29
29
|
|
|
30
30
|
|
|
31
31
|
※9999のみECでその他は店舗での購入としたい
|
|
32
32
|
|
|
33
|
-
|
|
33
|
+
※店舗コード salesstore
|
|
34
34
|
|
|
35
35
|
■実現したいこと
|
|
36
36
|
|
|
@@ -70,15 +70,11 @@
|
|
|
70
70
|
|
|
71
71
|
SUM(salesamt2 + discount3) AS 売上,
|
|
72
72
|
|
|
73
|
-
(CASE salesstore WHEN '
|
|
73
|
+
(CASE salesstore WHEN '9999' THEN 'EC' ELSE '店舗' END)AS チャネル
|
|
74
74
|
|
|
75
75
|
FROM saleswithcustomers
|
|
76
76
|
|
|
77
|
-
WHERE salesdivision='900'
|
|
78
|
-
|
|
79
|
-
AND ECSalesSumUpDate BETWEEN '2018-09-01' AND '2018-09-30'
|
|
80
|
-
|
|
81
|
-
GROUP BY (CASE salesstore WHEN '
|
|
77
|
+
GROUP BY (CASE salesstore WHEN '9999' THEN 'EC' ELSE '店舗' END)
|
|
82
78
|
|
|
83
79
|
```
|
|
84
80
|
|