text: CREATE TABLE people (People_ID VARCHAR, Height INTEGER); CREATE TABLE body_builder (Total INTEGER, People_ID VARCHAR) -- What is the average total score of body builders with height bigger than 200? SELECT AVG(T1.Total) FROM body_builder AS T1 JOIN people AS T2 ON T1.People_ID = T2.People_ID WHERE T2.Height > 200 CREATE TABLE body_builder (People_ID VARCHAR, Total VARCHAR); CREATE TABLE people (Name VARCHAR, People_ID VARCHAR) -- What are the names of body builders in descending order of total scores? SELECT T2.Name FROM body_builder AS T1 JOIN people AS T2 ON T1.People_ID = T2.People_ID ORDER BY T1.Total DESC CREATE TABLE people (Birth_Place VARCHAR) -- List each birth place along with the number of people from there. SELECT Birth_Place, COUNT(*) FROM people GROUP BY Birth_Place CREATE TABLE people (Birth_Place VARCHAR) -- What is the most common birth place of people? SELECT Birth_Place FROM people GROUP BY Birth_Place ORDER BY COUNT(*) DESC LIMIT 1 CREATE TABLE people (Birth_Place VARCHAR) -- What are the birth places that are shared by at least two people? SELECT Birth_Place FROM people GROUP BY Birth_Place HAVING COUNT(*) >= 2 CREATE TABLE people (Height VARCHAR, Weight VARCHAR) -- List the height and weight of people in descending order of height. SELECT Height, Weight FROM people ORDER BY Height DESC CREATE TABLE body_builder (Id VARCHAR) -- Show all information about each body builder. SELECT * FROM body_builder