How Can I write a SQL Query for this problem!!
Ex table:

Name True/False
------- --------------
John T
Marie T
Helen T
Mike F
John F
Helen T
Marie F
.
.
.
.
.

And requested result is!

Name True Count False Count
------- --------------- ----------------
John 2 4
Marie 6 9
Helen 6 0
.
.
.
.

How Can I do this?

Any help will be appreciated

Regards,

--

Tanz Anthrox
FB 1.5 / Delphi 7 / IBX