-- lowest scores by each golfer
select golfer_id,MIN(score) from rounds  group by golfer_id order by score asc

-- 5 lowest scores for a golfer
select golfer_id,score from rounds where golfer_id=1 order by score asc limit 5

-- 5 lowest handicaps for a golfer
select golfer_id,handicap from handicaps where golfer_id=1 order by handicap asc limit 5

-- Average, Min, Max scores for a golfer
select avg(score) as AvgScore,min(score) as LowScore,avg(points) as AvgPoints,max(points) as MaxPoints from rounds where golfer_id=1

-- Round history for golfer
select avg(score) as AvgScore,min(score) as LowScore,avg(points) as AvgPoints,max(points) as MaxPoints from rounds where golfer_id=1 

-- Calculate handicap for a golfer for this season
select truncate((avg(score)-36)*0.80,0) as Handicap  from rounds where golfer_id=1 and date > Date('2008-05-01')