And thanks for the link

Anyone have thoughts on the OpenOffice database program?

And, regarding Access as a front-end for MySQL, how difficult is that to set up? Does it basically just remove the file-size limitations that Access has? Do you lose any Access functionality? Do you still have to deal with MySQL at all?

I didn’t do the “extra credit,” but I think I did OK. It’s not really running in the background is it?

I like that it seems to be smaller and more efficient that I assume Access would be.

I’m eagerly awaiting Part 2, so that I can start completely move out of Excel for all my wasting-time-pretending-to-be-a-sabermetrician needs.

Maybe there can be a tutorial on how to take a table generated in Google Spreadsheets, MySQL, Excel, etc., and formatting it decently for SB Nation posts…. see my lame attempt (after way too much time spent on it) here.

can’t wait for your do-it-yourself-Marcels

I would also remove the spaces between the sum commands and the parenthesis.

Also, you’re can’t use an alias as a data column. So the final result looks like this:

select playerid,
sum(ipouts/3) as inn,
sum(er)/(sum(ipouts/3))*9 as era
from pitching
group by playerID
having inn >= 1000
order by era asc
limit 50;

Good catch on using Asc in the order by clause instead of Desc.