SQL Lab 2: Answers

What teams in history have won more than 100 games in a single season, chronologically?

SELECT year, name, wins FROM teams WHERE wins > 100 ORDER BY year;

What are the teams (and years) that have played at Guaranteed Rate Field?

SELECT year, name FROM teams WHERE park = "Guaranteed Rate Field";

What was the last team (and year) to play at U.S. Cellular Field?

SELECT year, name 
FROM teams 
WHERE park = "U.S. Cellular Field" 
ORDER BY year DESC
LIMIT 1;