Approved Workman Database

Community Contributions => SQL Workbench => Topic started by: Sherri on April 19, 2012, 12:43:39 AM

Title: Number of Extra Credit Sections
Post by: Sherri on April 19, 2012, 12:43:39 AM
I'm hoping that Rick will be able to incorporate the percentage of Extra Credit sections done somehow in his Current Handbook Status Summary, so that we can see who we need to plan to give Silver & Gold pins to in T&T.  But until then, I'm having to look within each clubber's handbook records to see who is getting close to finishing Silvers or Golds.  With this query, I can at least see who has said a bunch, then open only those records for further review.

I'm actually wondering if there is a better way to go about doing this (we don't print/maintain paper records to look at).  But until someone gives me a better idea, this is useful to me (& perhaps to someone else)

SELECT P.Person_ID, P.Mailing_Name AS "Name", SUM(PS.Extra_Section_Num) AS "Extra Sections"
FROM Person P, Person_Session PS
WHERE P.Person_ID = PS.Person_ID and P.Member_Type = 'Clubber' and Status = 'Active' and PS.Session_Date > '2011-09-01' and PS.Club_Name = 'T&T' and PS.Extra_Section_Num > 0
GROUP BY P.Person_ID
ORDER BY "Extra Sections" DESC