回答編集履歴
1
t訂正
answer
CHANGED
|
@@ -14,12 +14,12 @@
|
|
|
14
14
|
FROM(
|
|
15
15
|
SELECT
|
|
16
16
|
CASE
|
|
17
|
-
WHEN age <
|
|
17
|
+
WHEN age < 18 THEN 1
|
|
18
|
-
WHEN age <
|
|
18
|
+
WHEN age < 25 THEN 2
|
|
19
|
-
WHEN age <
|
|
19
|
+
WHEN age < 35 THEN 3
|
|
20
|
-
WHEN age <
|
|
20
|
+
WHEN age < 45 THEN 4
|
|
21
|
-
WHEN age <
|
|
21
|
+
WHEN age < 55 THEN 5
|
|
22
|
-
WHEN age <
|
|
22
|
+
WHEN age < 65 THEN 6
|
|
23
23
|
ELSE 7
|
|
24
24
|
END AS age_range
|
|
25
25
|
FROM(
|