
CREATE TABLE people (
	"People_ID" INTEGER, 
	"Nationality" TEXT, 
	"Name" TEXT, 
	"Birth_Date" TEXT, 
	"Height" REAL, 
	PRIMARY KEY ("People_ID")
)


CREATE TABLE poker_player (
	"Poker_Player_ID" INTEGER, 
	"People_ID" INTEGER, 
	"Final_Table_Made" REAL, 
	"Best_Finish" REAL, 
	"Money_Rank" REAL, 
	"Earnings" REAL, 
	PRIMARY KEY ("Poker_Player_ID"), 
	FOREIGN KEY("People_ID") REFERENCES people ("People_ID")
)

CREATE TABLE people (
	"People_ID" INTEGER, 
	"Nationality" TEXT, 
	"Name" TEXT, 
	"Birth_Date" TEXT, 
	"Height" REAL, 
	PRIMARY KEY ("People_ID")
)

/*
2 rows from people table:
People_ID	Nationality	Name	Birth_Date	Height
1	Russia	Aleksey Ostapenko	May 26, 1986	207.0
2	Bulgaria	Teodor Salparov	August 16, 1982	182.0
*/


CREATE TABLE poker_player (
	"Poker_Player_ID" INTEGER, 
	"People_ID" INTEGER, 
	"Final_Table_Made" REAL, 
	"Best_Finish" REAL, 
	"Money_Rank" REAL, 
	"Earnings" REAL, 
	PRIMARY KEY ("Poker_Player_ID"), 
	FOREIGN KEY("People_ID") REFERENCES people ("People_ID")
)

/*
2 rows from poker_player table:
Poker_Player_ID	People_ID	Final_Table_Made	Best_Finish	Money_Rank	Earnings
1	1	42.0	1.0	68.0	476090.0
2	2	10.0	2.0	141.0	189233.0
*/
Return the money rank of the poker player with the greatest height.
SELECT T2.Money_Rank FROM people AS T1 JOIN poker_player AS T2 ON T1.People_ID  =  T2.People_ID ORDER BY T1.Height DESC LIMIT 1
[{'Money_Rank': 68.0}]