I have a table like this
Name | DidA | DidB | DidC
Joe | true | false | true
Mary | false | true | false
Steve | true | false | true
I want a query that will count the 'true' in each column and display
it as it's own column
Count(DidA) | Count(DidB) | Count(DidC)
2 | 1 | 2
I'm not new to (my)sql programming, this is just for a personal
database so if I can't figure it out, it's not a big deal, but I'd
appreciate any help on this.