Display A Table From A Gridview But Every Column Has Its Own Where Arguments??

Hi,
please help me, i have a data driven site,
i need to display a table who look like this
 
Name            Total            Used            Remaining
A                    10                5                    5
B                    20                13                  7
C                    12                                    12 
 
if you would look on the field of total, used and remaining, they look like an excel formula which is total - used = remaining or vise versa.
but the problem in this table is the database, it look like this
name         On/Off
A                  1
A                   1
A                    0
and soon....... 
B                     1
B                     0
B                     1
and soon.... until C
 
so how do i count the total, is the number of A's or B's or C's in the whole database then Group By the 'name' field
then how do i count the used is the number of ON in the On/Off field while remaining is counting the Off,
so my question is i have RUN this using 3 different gridview each has its own datasource, that look like this
 
for the used  select name, count(on/off)
from myTable
where on/off = 1
group by name
 
for the  remaining select name, count(on/off)
from myTable
where on/off = 0
group by name
 
and for the total, just used the same Select but without the where clause,
i get this problem when the field "used"  (please refer from the 1st table) it has a blank value, which is because my data base show that in deed name "C" has not been used, but eve though it should show '0' instead of a blank,
 
so how can i do that???
please help me, thanks