Sangsom Sangsom - 4 months ago 78
SQL Question

Sean Lahman database sample queries

Is there any place where can I find sample queries (SELECT, UPDATE, DELETE) for Sean Lahman database? I wanna see what can be done with this database..

Answer

I use to ship the database with sample queries. Maybe I should revisit that idea. Here are a few to get you started.

A simple one to show all of the players named "Sean:"

SELECT nameLast, nameFirst, debut
FROM Master
WHERE (nameFirst="Sean")
ORDER BY nameLast;

Here's one to show a list of players with 50 HRs in a season:

SELECT Master.nameLast, Master.nameFirst, Batting.HR, Batting.yearID
FROM Batting INNER JOIN Master ON Batting.playerID = Master.playerID
WHERE (((Batting.HR)>=50))
ORDER BY Batting.HR DESC;

Here's one to show the all-time leaders in strikeouts:

SELECT Master.nameLast, Master.nameFirst, Sum(Pitching.SO) AS SumOfSO
FROM Pitching INNER JOIN Master ON Pitching.playerID = Master.playerID
GROUP BY Pitching.playerID, Master.nameLast, Master.nameFirst
ORDER BY Master.nameLast;

There are several websites with tutorials on using the database that include sample queries. See: http://webdev.cas.msu.edu/cas992/weeks/week5.html http://www.hardballtimes.com/main/article/databases-for-sabermetricians-part-one/

You can find more by googling 'sql lahman'