回答編集履歴
3
編集
answer
CHANGED
|
@@ -1,4 +1,4 @@
|
|
|
1
|
-
上の方
|
|
1
|
+
上の方のを参考に書かせていただきました。
|
|
2
2
|
```sql
|
|
3
3
|
select shop,count(status) status
|
|
4
4
|
from log
|
2
timestamp対応
answer
CHANGED
|
@@ -2,8 +2,8 @@
|
|
|
2
2
|
```sql
|
|
3
3
|
select shop,count(status) status
|
|
4
4
|
from log
|
|
5
|
-
where import_date >= '2016-08-01'
|
|
5
|
+
where import_date::date >= '2016-08-01'
|
|
6
|
-
AND import_date <= '2016-08-04'
|
|
6
|
+
AND import_date::date <= '2016-08-04'
|
|
7
7
|
AND status = 'NG'
|
|
8
8
|
group by 1 order by 1
|
|
9
9
|
```
|
1
変更
answer
CHANGED
|
@@ -5,5 +5,5 @@
|
|
|
5
5
|
where import_date >= '2016-08-01'
|
|
6
6
|
AND import_date <= '2016-08-04'
|
|
7
7
|
AND status = 'NG'
|
|
8
|
-
group by 1
|
|
8
|
+
group by 1 order by 1
|
|
9
9
|
```
|