I have a table with 3 columns:
status contains numbers and rank contains t or f.
key is auto numbered and irrelevant here.
my goal is to count how many in each status are t and how many false for example:
if my data is (key, status, rank)
1 10 f 2 10 t 3 10 t 4 11 t
then result will be : (status, rank, count value)
10 f 1 10 t 2 11 t 1
how do i do that?