Hi Everyone,
I am having some trouble with this query:
I have a table which holds information about legal cases which have applied for financial aid. In this table there is a field for the case category (fraud, tort, etc.) and a field for whether or not the case got approved for financial aid (approved or denied).
I want to design a query that is grouped by case category. Then, I want to count the number of cases in that category which were approved, and I want to count the number of cases in that category which were denied.
If anyone knows how to do this, I would greatly appreciate it. Thanks!