SQL Practice 6

2023년 8월 1일

1. 문제 [[object Object]]

각 환자의 이름, 성 및 전체 주 이름을 표시합니다.

예: 'ON' 대신 'Ontario'

patient_id	first_name	last_name	gender	birth_date	city	province_id	allergies	height	weight
1	Donald	Waterfield	M	1963-02-12	Barrie	ON	NULL	156	65
2	Mickey	Baasha	M	1981-05-28	Dundas	ON	Sulfa	185	76
3	Jiji	Sharma	M	1957-09-05	Hamilton	ON	Penicillin	194	106
4	Blair	Diaz	M	1967-01-07	Hamilton	ON	NULL	191	104
5	Charles	Wolfe	M	2017-11-19	Orillia	ON	Penicillin	47	10
6	Sue	Falcon	F	2017-09-30	Ajax	ON	Penicillin	43	5

SELECT first_name, last_name, province_names.province_name
FROM patients, province_names
WHERE patients.province_id = province_names.province_id;

SELECT first_name, last_name, province_name
FROM patients
JOIN province_names ON province_names.province_id = patients.province_id;

OUTER JOIN