Multiple Counts with 1 SQL Statement?
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 :(.