Sample Bayou Grand Prix SQL

gistfile1.sql

select d.name, t.color, SUM(sg.points), t.name
from raceresults rr, races r, scoring sg, drivers d, 
teams t, seasondrivers sd, schedule k where
k.season = $season and
k.race = r.id and 
rr.race = r.id and
rr.driver = d.id and
rr.place = sg.place and
rr.dnf = FALSE and
sd.driver = d.id and
sd.defaultteam = t.id and
sd.season = k.season and
sg.scheme = $schemeid
group by d.name, t.color, t.name
order by 3 desc, 1;