Table: cole_aldrich
Columns: name
position
height
weight
year
home_town

Question: What is the Weight of the Senior Player with a Height of 6–10?
SQL: SELECT SUM("weight") FROM cole_aldrich WHERE "year" = 'senior' AND "height" = '6–10'

Question: What is the Year of the Player with a Weight of 230 or less from San Antonio, Texas?
SQL: SELECT "year" FROM cole_aldrich WHERE "weight" < 230 AND "home_town" = 'san antonio, texas'

Question: What is the Height of the Sophomore Guard weighing 185?
SQL: SELECT "height" FROM cole_aldrich WHERE "year" = 'sophomore' AND "position" = 'guard' AND "weight" = 185

Question: What is the Year of the Player weighing 185?
SQL: SELECT "year" FROM cole_aldrich WHERE "weight" = 185