質問編集履歴
1
誤字修正\(LAST_NAME → FIRST_NAME\)
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -11,7 +11,7 @@
|
|
|
11
11
|
```
|
|
12
12
|
[ORDER_NO] [char](13) NOT NULL,
|
|
13
13
|
[FAMILY_NAME] [varchar](20) NULL, -- 姓
|
|
14
|
-
[
|
|
14
|
+
[FIRST_NAME] [varchar](20) NULL -- 名
|
|
15
15
|
```
|
|
16
16
|
【期待する結果(例)】
|
|
17
17
|
> 1 , 髙, 100
|
|
@@ -26,15 +26,15 @@
|
|
|
26
26
|
--例「あ」～「お」までの出現数を数える
|
|
27
27
|
SELECT
|
|
28
28
|
SUM(LEN(FAMILY_NAME) - LEN(REPLACE(FAMILY_NAME, 'あ', '')))
|
|
29
|
-
+ SUM(LEN(
|
|
29
|
+
+ SUM(LEN(FIRST_NAME) - LEN(REPLACE(FIRST_NAME, 'あ', ''))) AS 'あ',
|
|
30
30
|
SUM(LEN(FAMILY_NAME) - LEN(REPLACE(FAMILY_NAME, 'い', '')))
|
|
31
|
-
+ SUM(LEN(
|
|
31
|
+
+ SUM(LEN(FIRST_NAME) - LEN(REPLACE(FIRST_NAME, 'い', '')))AS 'い',
|
|
32
32
|
SUM(LEN(FAMILY_NAME) - LEN(REPLACE(FAMILY_NAME, 'う', '')))
|
|
33
|
-
+ SUM(LEN(
|
|
33
|
+
+ SUM(LEN(FIRST_NAME) - LEN(REPLACE(FIRST_NAME, 'う', ''))) AS 'う',
|
|
34
34
|
SUM(LEN(FAMILY_NAME) - LEN(REPLACE(FAMILY_NAME, 'え', '')))
|
|
35
|
-
+ SUM(LEN(
|
|
35
|
+
+ SUM(LEN(FIRST_NAME) - LEN(REPLACE(FIRST_NAME, 'え', ''))) AS 'え',
|
|
36
36
|
SUM(LEN(FAMILY_NAME) - LEN(REPLACE(FAMILY_NAME, 'お', '')))
|
|
37
|
-
+ SUM(LEN(
|
|
37
|
+
+ SUM(LEN(FIRST_NAME) - LEN(REPLACE(FIRST_NAME, 'お', ''))) AS 'お'
|
|
38
38
|
FROM CUSTOMER_INFO
|
|
39
39
|
```
|
|
40
40
|
|