Baseball Query

Sample select statements:

* from Batting where playerID='mantlmi01';
playername as Name, yearID as Year, HR from Batting where HR>=50 order by HR DESC;
playername as Name, yearID as Year, BA from Batting where yearID>1900 and AB>400 order by BA DESC limit 10;
playername as Name, yearID as Year, W as Wins from Pitching where yearID>1900 order by W DESC limit 10;
playername as Name, yearID as Year, PO from Fielding where lgID='AL' order by PO DESC limit 10;

Enter select statement:

Data from www.baseball-databank.org