質問編集履歴
1
誤字修正\(LAST_NAME → FIRST_NAME\)
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -24,7 +24,7 @@
|
|
|
24
24
|
|
|
25
25
|
[FAMILY_NAME] [varchar](20) NULL, -- 姓
|
|
26
26
|
|
|
27
|
-
[
|
|
27
|
+
[FIRST_NAME] [varchar](20) NULL -- 名
|
|
28
28
|
|
|
29
29
|
```
|
|
30
30
|
|
|
@@ -54,23 +54,23 @@
|
|
|
54
54
|
|
|
55
55
|
SUM(LEN(FAMILY_NAME) - LEN(REPLACE(FAMILY_NAME, 'あ', '')))
|
|
56
56
|
|
|
57
|
-
+ SUM(LEN(
|
|
57
|
+
+ SUM(LEN(FIRST_NAME) - LEN(REPLACE(FIRST_NAME, 'あ', ''))) AS 'あ',
|
|
58
58
|
|
|
59
59
|
SUM(LEN(FAMILY_NAME) - LEN(REPLACE(FAMILY_NAME, 'い', '')))
|
|
60
60
|
|
|
61
|
-
+ SUM(LEN(
|
|
61
|
+
+ SUM(LEN(FIRST_NAME) - LEN(REPLACE(FIRST_NAME, 'い', '')))AS 'い',
|
|
62
62
|
|
|
63
63
|
SUM(LEN(FAMILY_NAME) - LEN(REPLACE(FAMILY_NAME, 'う', '')))
|
|
64
64
|
|
|
65
|
-
+ SUM(LEN(
|
|
65
|
+
+ SUM(LEN(FIRST_NAME) - LEN(REPLACE(FIRST_NAME, 'う', ''))) AS 'う',
|
|
66
66
|
|
|
67
67
|
SUM(LEN(FAMILY_NAME) - LEN(REPLACE(FAMILY_NAME, 'え', '')))
|
|
68
68
|
|
|
69
|
-
+ SUM(LEN(
|
|
69
|
+
+ SUM(LEN(FIRST_NAME) - LEN(REPLACE(FIRST_NAME, 'え', ''))) AS 'え',
|
|
70
70
|
|
|
71
71
|
SUM(LEN(FAMILY_NAME) - LEN(REPLACE(FAMILY_NAME, 'お', '')))
|
|
72
72
|
|
|
73
|
-
+ SUM(LEN(
|
|
73
|
+
+ SUM(LEN(FIRST_NAME) - LEN(REPLACE(FIRST_NAME, 'お', ''))) AS 'お'
|
|
74
74
|
|
|
75
75
|
FROM CUSTOMER_INFO
|
|
76
76
|
|