Show the ages of gymnasts in descending order of total points.
select t2.age from gymnast as t1 join people as t2 on t1.gymnast_id = t2.people_id order by t1.total_points desc
Show their names.
select t2.name from gymnast as t1 join people as t2 on t1.gymnast_id = t2.people_id order by t1.total_points desc
What is the height of Paul Hamm?
select height from people where name = 'Paul Hamm'
What is his hometown?
select hometown from people where name = 'Paul Hamm'
How many total points does he have?
select sum ( total_points ) from gymnast as t1 join people as t2 on t1.gymnast_id = t2.people_id where t2.name = 'Paul Hamm'
How many rings points does he have?
select rings_points from gymnast as t1 join people as t2 on t1.gymnast_id = t2.people_id where t2.name = 'Paul Hamm'