Baseball Examples

SELECT * FROM parks LIMIT 10;

SELECT franchName FROM teamsfranchises WHERE active=='N' LIMIT 10;

-- Find the playerID
SELECT playerID FROM batting WHERE RBI==191;

-- Display the name
SELECT
	nameFirst,
	nameLast
FROM
	people
WHERE
	playerID == 'wilsoha01';

SELECT
	playerID
FROM
	managers
WHERE
	yearID == 1976
	AND teamID == 'CIN';

SELECT
	nameFirst,
	nameLast
FROM
	people
WHERE
	playerID == 'andersp01';

SELECT
	playerID
FROM
	people
WHERE
	nameLast == 'LaRussa'
	AND nameFirst == 'Tony';

SELECT DISTINCT
	teamID
FROM
	managers
WHERE
	playerID == 'larusto01';

SELECT
	playerID
FROM
	people
WHERE
	nameFirst == 'Cecil'
	AND nameLast == 'Fielder';

SELECT
	teamID,
	salary
FROM
	salaries
WHERE
	playerID == 'fieldce01'
	AND yearID == 1987;

SELECT
	teamIDloser,
	yearID
FROM
	seriespost
WHERE
	yearID >= 1990
	AND round == 'WS'
ORDER BY
	yearID ASC
LIMIT 10;

SELECT
	height,
	weight,
	bats,
	finalgame
FROM
	people
WHERE
	nameFirst == 'Cal'
	AND nameLast == 'Ripken'
	AND deathState IS NULL;

SELECT
	playerID,
	yearID
FROM
	halloffame
WHERE
	votedBy == 'Veterans'
	AND inducted == 'Y'
	AND yearID BETWEEN 1990 AND 2000
ORDER BY
	yearID DESC
LIMIT 10;

SELECT
	yearkey,
	attendance
FROM
	homegames
WHERE
	teamkey == 'TOR'
ORDER BY
	attendance DESC
LIMIT 10;

SELECT DISTINCT league FROM leagues;

SELECT teamID, yearID FROM teams WHERE WSWin=='Y' LIMIT 10;

SELECT teamID, yearID, W FROM teams ORDER BY W DESC LIMIT 10;

SELECT
	playerID,
	teamID,
	W,
	L,
	CG
FROM
	pitching
WHERE
	CG > 0
	AND yearID == 1995
ORDER BY
	W DESC
LIMIT 10;

SELECT
	playerID
FROM
	people
WHERE
	nameFirst == 'Ichiro'
	AND nameLast == 'Suzuki';

SELECT
	teamID,
	yearID,
	H,
	HR
FROM
	batting
WHERE
	playerID == 'suzukic01';

SELECT
	playerID
FROM
	people
WHERE
	nameFirst == 'Mariano'
	AND nameLast == 'Rivera';

SELECT
	yearID,
	teamID,
	BB,
	SO
FROM
	pitchingpost
WHERE
	playerID == 'riverma01'
ORDER BY
	BB DESC;

SELECT
	playerID,
	SO
FROM
	pitching
WHERE
	yearID == 2014
ORDER BY
	SO DESC
LIMIT (10);

SELECT
	playerID,
	SO
FROM
	batting
WHERE
	yearID == 2014
ORDER BY
	SO DESC
LIMIT (10);

SELECT
	nameFirst,
	nameLast
FROM
	people
WHERE
	playerID == "klubeco01"
	OR playerID == "howarry01";

SELECT
	playerID
FROM
	people
WHERE
	nameFirst == 'Bartolo'
	AND nameLast == 'Colon';

SELECT COUNT(DISTINCT teamID) FROM pitching WHERE playerID == 'colonba01';

SELECT
	playerID
FROM
	people
WHERE
	nameFirst == "Trevor"
	AND nameLast == "Bauer";

SELECT
	AB,
	H
FROM
	batting
WHERE
	playerID == "bauertr01"
	AND yearID == "2016";

SELECT
	playerID,
	nameFirst,
	nameLast
FROM
	people
WHERE (nameFirst == 'Giancarlo'
	AND nameLast == 'Stanton')
	OR(nameFirst == 'Mike'
		AND nameLast == 'Trout');

SELECT
	playerID,
	yearID,
	teamID,
	RBI,
	CS
FROM
	batting
WHERE
	playerID == 'stantmi03'
	OR playerID == 'troutmi01'
ORDER BY
	RBI DESC
LIMIT 1;

SELECT
	playerID,
	yearID,
	teamID,
	RBI,
	CS
FROM
	batting
WHERE
	playerID == 'stantmi03'
	OR playerID == 'troutmi01'
ORDER BY
	CS DESC
LIMIT 1;

SELECT
	playerID,
	yearID,
	teamID,
	BB,
	SO
FROM
	batting
WHERE
	BB > SO
LIMIT 10;

SELECT nameFirst, nameLast FROM people WHERE playerID=='randowi01';

SELECT DISTINCT
	playerID
FROM
	awardsplayers
WHERE
	awardID == 'Gold Glove'
	AND notes == 'C'
	AND lgID == 'NL'
	AND yearID BETWEEN 1990 AND 2000;

SELECT DISTINCT
	playerID,
	yearID,
	E
FROM
	fielding
WHERE
	yearID BETWEEN 2000 AND 2005
	AND teamID == 'SEA'
	AND POS == '3B'
ORDER BY
	E DESC
LIMIT 10;

SELECT
	nameFirst,
	nameLast
FROM
	people
WHERE
	playerID == 'camermi01';

SELECT
	playerID
FROM
	people
WHERE
	nameFirst == 'Craig'
	AND nameLast == 'Biggio';

SELECT
	teamID,
	yearID,
	POS
FROM
	fielding
WHERE
	playerID == 'biggicr01'
	AND POS == 'C';

SELECT
	teamID,
	yearID
FROM
	teams
WHERE
	WSWin == 'Y'
	AND lgID == 'NL'
ORDER BY
	yearID ASC
LIMIT 10;

SELECT
	playerID,
	W,
	L,
	CG
FROM
	pitching
WHERE
	CG > 0
	AND yearID == 1995
ORDER BY
	CG DESC
LIMIT 10;

SELECT
	nameFirst,
	nameLast
FROM
	people
WHERE
	playerID == 'maddugr01';

SELECT
	playerID,
	yearID
FROM
	managers
WHERE
	plyrMgr == 'Y'
ORDER BY
	yearID DESC
LIMIT 10;

SELECT
	nameFirst,
	nameLast
FROM
	people
WHERE
	playerID == 'rosepe01';

SELECT
	playerID
FROM
	people
WHERE
	nameFirst == 'Roberto'
	AND nameLast == 'Clemente';

SELECT
	yearID,
	AB,
	HR,
	SB
FROM
	battingpost
WHERE
	playerID == 'clemero01'
ORDER BY
	yearID ASC;

SELECT
	playerID
FROM
	people
WHERE
	nameFirst == 'Tom'
	AND nameLast == 'Lasorda';

SELECT
	yearID
FROM
	managers
WHERE
	playerID == 'lasorto01'
LIMIT 10;

SELECT DISTINCT
	teamID
FROM
	teams
WHERE
	WSWin == 'Y'
	AND yearID BETWEEN 1976 AND 1996;

SELECT
	playerID
FROM
	people
WHERE
	nameFirst == 'Kenny'
	AND nameLast == 'Lofton';

SELECT
	teamID,
	yearID,
	SB
FROM
	batting
WHERE
	playerID == 'loftoke01'
	AND SB > 20
	AND yearID > 2000;

SELECT
	playerID
FROM
	people
WHERE
	nameFirst == 'Wade'
	AND nameLast == 'Boggs';

SELECT
	teamID,
	yearID,
	salary
FROM
	salaries
WHERE
	playerID == 'boggswa01'
	AND yearID == 1998;

SELECT
	teamID,
	yearID,
	salary
FROM
	salaries
WHERE
	playerID == 'boggswa01'
ORDER BY
	salary DESC
LIMIT 10;

SELECT
	teamID,
	W,
	L
FROM
	teams
WHERE
	divID == 'E'
	AND lgID == 'NL'
	AND yearID == 2015
ORDER BY
	teamrank ASC;

SELECT
	teamID,
	yearID,
	W,
	L
FROM
	teams
WHERE
	lgID == 'NL'
	AND divID == 'E'
	AND WSWin == 'Y'
ORDER BY
	W DESC;

SELECT
	playerID,
	teamID,
	yearID,
	W,
	L
FROM
	managers
WHERE
	yearID BETWEEN 1930 AND 1950
	AND W > L
ORDER BY
	W DESC
LIMIT 10;

SELECT
	nameFirst,
	nameLast
FROM
	people
WHERE
	playerID == 'mackco01';

SELECT
	franchName
FROM
	teamsfranchises
WHERE
	franchID == 'PHA';

SELECT
	teamID,
	yearID,
	attendance
FROM
	teams
WHERE
	franchID == 'TBD'
	OR franchID == 'FLA'
ORDER BY
	attendance DESC
LIMIT 10;

SELECT
	playerID,
	teamID,
	yearID,
	SHO
FROM
	pitching
WHERE
	yearID > 2010
	AND lgID == 'NL'
ORDER BY
	SHO DESC
LIMIT 10;

SELECT
	playerID,
	teamID,
	yearID,
	SHO
FROM
	pitching
WHERE
	yearID > 2010
	AND lgID == 'AL'
ORDER BY
	SHO DESC
LIMIT 10;

SELECT
	nameFirst,
	nameLast
FROM
	people
WHERE
	playerID == 'leecl02'
	OR playerID == 'hernafe02';