I have an attendance table in SQL Server 2012 named tblOrgHours. (attached) This is where I log all my attendance for different agencies in tracking how many hours each activity has been performed each day by different kids. The ActivityID in this table is relational with tblOrgActivity. (attached) The RegID in that same table is relational with the student information found in table tblOrgRegistrations. (attached) I need to create an sql query that will output unduplicated counts of the kids who had greater than 0 hours
of service during a specified period of time
. The unduplicated demographic counts are broken out as you see in the attached output file.
After looking at my output, how is is possible to get all this information pulled up from one sql query?