
CREATE TABLE gymnast (
	"Gymnast_ID" INTEGER, 
	"Floor_Exercise_Points" REAL, 
	"Pommel_Horse_Points" REAL, 
	"Rings_Points" REAL, 
	"Vault_Points" REAL, 
	"Parallel_Bars_Points" REAL, 
	"Horizontal_Bar_Points" REAL, 
	"Total_Points" REAL, 
	PRIMARY KEY ("Gymnast_ID"), 
	FOREIGN KEY("Gymnast_ID") REFERENCES people ("People_ID")
)


CREATE TABLE people (
	"People_ID" INTEGER, 
	"Name" TEXT, 
	"Age" REAL, 
	"Height" REAL, 
	"Hometown" TEXT, 
	PRIMARY KEY ("People_ID")
)

CREATE TABLE gymnast (
	"Gymnast_ID" INTEGER, 
	"Floor_Exercise_Points" REAL, 
	"Pommel_Horse_Points" REAL, 
	"Rings_Points" REAL, 
	"Vault_Points" REAL, 
	"Parallel_Bars_Points" REAL, 
	"Horizontal_Bar_Points" REAL, 
	"Total_Points" REAL, 
	PRIMARY KEY ("Gymnast_ID"), 
	FOREIGN KEY("Gymnast_ID") REFERENCES people ("People_ID")
)

/*
2 rows from gymnast table:
Gymnast_ID	Floor_Exercise_Points	Pommel_Horse_Points	Rings_Points	Vault_Points	Parallel_Bars_Points	Horizontal_Bar_Points	Total_Points
1	9.725	9.737	9.512	9.575	9.762	9.75	58.061
2	9.7	9.625	9.625	9.65	9.587	9.737	57.924
*/


CREATE TABLE people (
	"People_ID" INTEGER, 
	"Name" TEXT, 
	"Age" REAL, 
	"Height" REAL, 
	"Hometown" TEXT, 
	PRIMARY KEY ("People_ID")
)

/*
2 rows from people table:
People_ID	Name	Age	Height	Hometown
1	Paul Hamm	24.0	1.71	Santo Domingo
2	Lorraine Súarez Carmona	21.0	1.75	Bonao
*/
What is the age of the tallest person?
SELECT Age FROM people ORDER BY Height DESC LIMIT 1
[{'Age': 23.0}]