SQL Practice 8

2023년 8월 2일

1. 문제 [[object Object]]

키가 가장 큰 환자의 성, 이름, 신장을 표시하시오.

patient_id	first_name	last_name	gender	birth_date	city	province_id	allergies	height	weight
301	Ricardo	Andrews	M	1987-07-21	Hamilton	ON	NULL	177	112
302	Paul	Vondopoulos	M	2010-05-22	Brantford	ON	NULL	107	36
303	Agnes	Parkinson	F	1975-01-11	Hamilton	ON	Sulfa Drugs	158	47
304	Jeffrey	Pascoe	M	1957-05-12	Hamilton	ON	Sulfa	174	84
305	Amane	Flute	F	2006-03-27	Hamilton	ON	NULL	130	48
306	Matt	Franchetti	M	2007-09-25	Burlington	ON	Milk	157	60

SELECT
  first_name,
  last_name,
  MAX(height) AS height
FROM patients;

SELECT
  first_name,
  last_name,
  height
FROM patients
WHERE height = (
  SELECT max(height)
  FROM patients
)

first_name	last_name	height
Ricardo	Andrews	177