Races Run Tracking

• Update races run each week after the results are posted from BRAC.
• Send out emails as required.

MESSAGE

Races Purchased by weeks:

[abase sql="SELECT RacesPurch as 'Number of Races', COUNT(*) as 'Purchased' FROM Racers group by RacesPurch;"]

Series Purchases vs. Walk ups:

[abase sql="SELECT Multi, COUNT(*) as 'Number' FROM Racers GROUP BY Multi;"]

Total Races Purchased:

[abase sql="SELECT SUM(RacesPurch) FROM Racers;"]

Total Races Run:

[abase sql="SELECT SUM(RacesRun) FROM Racers;"]

Races Purchased Equals Races Run (send emails):

[abase sql="SELECT LastName as 'Last', FirstName as 'First', License, RacesPurch as 'Purch', RacesRun as 'Run', EmailSent as 'Email Sent', Multi FROM Racers WHERE RacesPurch = RacesRun and Multi = 'Yes';"]

Racers who have not raced:

[abase sql="SELECT LastName as 'Last', FirstName as 'First', License, RacesPurch as 'Purch', RacesRun as 'Run' FROM Racers WHERE RacesRun = 0;"]

List of Races Purchased/Run

[abase sql="SELECT LastName as 'Last', FirstName as 'First', License, RacesPurch as 'Purch', RacesRun as 'Run', Multi FROM Racers order by RacesPurch, LastName;"]