这是我的前台呼叫培训

+-------+-----------+-----------+-----------+
| Name  | FootNov12 | HandNov15 | FootNov22 |
+-------+-----------+-----------+-----------+
| Clem  | x         | Abs       | Abs       |
+-------+-----------+-----------+-----------+
| Kevin | x         | x         | x         |
+-------+-----------+-----------+-----------+

我想选择球员来足部训练的名字和次数。

FootNov12 = Football Novembrre 12th
FootNov22 = Football November 22th
HandNov15 = Handball November 15th

select查询应提供：

Name | Count
Clem |  1
Kevin|  2

但我不知道怎么做谢谢你的帮助。