영어로 된 국가 이름 중에서 어떤 알파벳으로 시작하는 나라가 가장 많을까요?

영어 알파벳은 A부터 Z까지 있습니다.

한국은 South Korea, S로 시작하지요.

미국은 Unisted States, U로 시작합니다.

 

각 국가명 주엥서 어떤 영어 알파벳으로 시작하는 나라가 가장 많을까요?

 

정답부터 말하면 S가 제일 많았습니다.

 

알파벳	국가 갯수
S	29
C	22
M	22
B	20
A	15
G	15
N	15
T	13
P	12
L	9
E	8
F	8
I	8
U	8
H	6
K	5
V	5
D	4
R	4
J	3
W	2
Y	2
Z	2
O	1
Q	1
X	0

 

알아낸 방법

https://dev.mysql.com/doc/index-other.html

MySQL :: Other MySQL Documentation

mysql에서 샘플 데이터를 다운로드 받습니다.

 

mysql에서 실행시키고 아래 SQL 쿼리문을 실행시킵니다.

use world;
SELECT COUNT(*) AS 'A Country' FROM country WHERE name LIKE 'A%';
SELECT COUNT(*) AS 'B Country' FROM country WHERE name LIKE 'B%';
SELECT COUNT(*) AS 'C Country' FROM country WHERE name LIKE 'C%';
SELECT COUNT(*) AS 'D Country' FROM country WHERE name LIKE 'D%';
SELECT COUNT(*) AS 'E Country' FROM country WHERE name LIKE 'E%';
SELECT COUNT(*) AS 'F Country' FROM country WHERE name LIKE 'F%';
SELECT COUNT(*) AS 'G Country' FROM country WHERE name LIKE 'G%';
SELECT COUNT(*) AS 'H Country' FROM country WHERE name LIKE 'H%';
SELECT COUNT(*) AS 'I Country' FROM country WHERE name LIKE 'I%';
SELECT COUNT(*) AS 'J Country' FROM country WHERE name LIKE 'J%';
SELECT COUNT(*) AS 'K Country' FROM country WHERE name LIKE 'K%';
SELECT COUNT(*) AS 'L Country' FROM country WHERE name LIKE 'L%';
SELECT COUNT(*) AS 'M Country' FROM country WHERE name LIKE 'M%';
SELECT COUNT(*) AS 'N Country' FROM country WHERE name LIKE 'N%';
SELECT COUNT(*) AS 'O Country' FROM country WHERE name LIKE 'O%';
SELECT COUNT(*) AS 'P Country' FROM country WHERE name LIKE 'P%';
SELECT COUNT(*) AS 'Q Country' FROM country WHERE name LIKE 'Q%';
SELECT COUNT(*) AS 'R Country' FROM country WHERE name LIKE 'R%';
SELECT COUNT(*) AS 'S Country' FROM country WHERE name LIKE 'S%';
SELECT COUNT(*) AS 'T Country' FROM country WHERE name LIKE 'T%';
SELECT COUNT(*) AS 'U Country' FROM country WHERE name LIKE 'U%';
SELECT COUNT(*) AS 'V Country' FROM country WHERE name LIKE 'V%';
SELECT COUNT(*) AS 'W Country' FROM country WHERE name LIKE 'W%';
SELECT COUNT(*) AS 'X Country' FROM country WHERE name LIKE 'X%';
SELECT COUNT(*) AS 'Y Country' FROM country WHERE name LIKE 'Y%';
SELECT COUNT(*) AS 'Z Country' FROM country WHERE name LIKE 'Z%';