
CREATE TABLE body_builder (
	"Body_Builder_ID" INTEGER, 
	"People_ID" INTEGER, 
	"Snatch" REAL, 
	"Clean_Jerk" REAL, 
	"Total" REAL, 
	PRIMARY KEY ("Body_Builder_ID"), 
	FOREIGN KEY("People_ID") REFERENCES people ("People_ID")
)


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

CREATE TABLE body_builder (
	"Body_Builder_ID" INTEGER, 
	"People_ID" INTEGER, 
	"Snatch" REAL, 
	"Clean_Jerk" REAL, 
	"Total" REAL, 
	PRIMARY KEY ("Body_Builder_ID"), 
	FOREIGN KEY("People_ID") REFERENCES people ("People_ID")
)

/*
2 rows from body_builder table:
Body_Builder_ID	People_ID	Snatch	Clean_Jerk	Total
1	1	142.5	175.0	317.5
2	2	137.5	177.5	315.0
*/


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

/*
2 rows from people table:
People_ID	Name	Height	Weight	Birth_Date	Birth_Place
1	Jack Campbell	182.0	80.0	January 1, 1992	Port Huron, Michigan
2	Ty Conklin	192.0	90.0	March 30, 1976	Anchorage, Alaska
*/
What are the birth date and birth place of the body builder with the highest total points?
SELECT T2.Birth_Date ,  T2.Birth_Place FROM body_builder AS T1 JOIN people AS T2 ON T1.People_ID  =  T2.People_ID ORDER BY T1.Total DESC LIMIT 1
[{'Birth_Date': 'January 1, 1992', 'Birth_Place': 'Port Huron, Michigan'}]