
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
*/
How many body builders are there?
SELECT count(*) FROM body_builder
[{'count(*)': 5}]