Tuesday, November 6, 2007

quarterback query

I just rezzed out this query, on Green Phosphor Island:

totem_rez 1 grid yards .3 {select s.year, s.year, s.id, concat(p.fname, concat(' ', p.lname)), s.passyd from seasons s, players p, (select id, sum(att) as catt from seasons where position = 'qb' group by id) c where s.position = 'qb' and s.id = c.id and c.catt > 800 and s.id = p.id and s.year > 1986 and s.year < 2005 group by s.year, s.id order by s.year, s.id}


Check out your favorite quarterback. I like two in particular: Marino and Favre.


go here for a slurl to the island


Ben

No comments: