simple SQL example

[thewaxtadpole]

Given the following two database tables, team and player, write a SQL statement that would return a list of names of the top 10 teams sorted from the tallest average player to the shortest. Assume that player height is stored as an integer representing number of inches.

[TABLE="width: 528"]
<colgroup><col><col width="*"></colgroup><tbody>[TR]
[TD]team
--------
id
name
league
division
[/TD]
[TD]player
--------
id
name
height
weight
team_id
[/TD]
[/TR]
</tbody>[/TABLE]

 

[RoryA]

Homework?