sql count conditions
- by user1311030
there!
I have this question, hope you guys can help me out.
So i have this table with two fields:
type and authorization
in type i have 2 different values: Raid and Hold
in authorization i have 2 different values: Accepted or Denied
I need to make a view that returns values like this:
TYPE:RAID ACCEPTED:5 DENIED:7
Basically i need to know how many of the values in TYPE are Raid, and then how many of
them are Accepted and Denied.
Thank you in advance!!