SQL Lab 1: Answers

The teams that play professional baseball can change every year (e.g. expansion teams, teams moving, renaming, etc). List the year and team name of every baseball team that has ever played.

SELECT year, name FROM teams;

Can I see a list of all teams by year and number of wins, starting with the fewest wins?

SELECT year, name, wins FROM teams ORDER BY wins;

Which three teams had the losingest seasons?

SELECT year, name, wins, losses
FROM teams
ORDER BY losses DESC
LIMIT 3;