Re: [sqlite] FW: Need Help with Golf Handicap Calculation

2014-02-09 Thread Keith Medcalf
te-users-boun...@sqlite.org [mailto:sqlite-users- >boun...@sqlite.org] On Behalf Of James K. Lowden >Sent: Sunday, February 09, 2014 6:04 PM >To: sqlite-users@sqlite.org >Subject: Re: [sqlite] FW: Need Help with Golf Handicap Calculation > >On Sat, 8 Feb 2014 19:47:44 + >Ed Tenholder <

Re: [sqlite] FW: Need Help with Golf Handicap Calculation

2014-02-09 Thread Ed Tenholder
...@sqlite.org] On Behalf Of James K. Lowden Sent: Sunday, February 09, 2014 6:04 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] FW: Need Help with Golf Handicap Calculation On Sat, 8 Feb 2014 19:47:44 + Ed Tenholder <e...@tenholder.net> wrote: > Query: SELECT MAX(ScoreDate),AVG((Sco

Re: [sqlite] FW: Need Help with Golf Handicap Calculation

2014-02-09 Thread James K. Lowden
On Sat, 8 Feb 2014 19:47:44 + Ed Tenholder wrote: > Query: SELECT MAX(ScoreDate),AVG((Score-Rating)*(113.0/Slope))*.96 > FROM (SELECT * FROM (SELECT * FROM (SELECT > ScoreDate,Score,Rating,Slope FROM Scores WHERE Player="Joe Smith" > ORDER BY ScoreDate ASC LIMIT 3)

[sqlite] FW: Need Help with Golf Handicap Calculation

2014-02-08 Thread Ed Tenholder
From: Ed Tenholder Sent: Saturday, February 08, 2014 1:44 PM To: 'sqlite-users@sqlite.org' Subject: Need Help with Golf Handicap Calculation I’m just trying to learn SQL, and after lots of google searches and reading posts on this email list, I’ve gotten pretty close. Table: CREATE