Here's the jist of what I'm trying to do:

Use one SQL statement to pull all records from a db within a certain date range.

From there I want to be able to count how many people answered "column1" a certain way.

So for example I have a table with "Employee Type". Is it possible for me to do this with just one SQL statement?

Faculty: [ # of people who answered "Faculty" in "Employee_Type" column ]
Staff: [ # of people who answered "Staff" in "Employee_Type" column ]

Thanks for any help I can get on this. It's been way too long since I've done any of this manual SQL/PHP stuff. I normally work in frameworks nowadays so my knowledge of the basics is... gone .