SQLZOO, How can I select the oldest person in the table PERSON by birthday?

MySQL
I have a table `PERSON(personID, name, sex, birthday, placeOfBirth)` Now I would like to SELECT the oldest person in the table by birthday. Answer: Use a nested query to find the earliest birthday.	-- Set up the table DROP TABLE people; CREATE TABLE people(personId INTEGER PRIMARY KEY, name VARCHAR(20), sex CHAR(1), birthday DATE, placOfBirth VARCHAR(20)); INSERT INTO people VALUES (1,'Oliver','M','1985-05-25','Bedford'); INSERT INTO people VALUES (2,'Andrew','M','1962-05-20','Hong Kong'); --Here is the answer SELECT * FROM people ORDER BY birthday ASC LIMIT 1
Specific to MySQL
We can order by birthday and select the first one only. If there are two or more oldest people then only one of them will be returned.

SQLzoo.net