select count(fk_OrderType)OrderCount, OrderName
from TrainingOrders group by fk_ActionTrainingType

OrderName  OrderCount
A            10
B            5
C            7
D            3

OrderName   ORderCount
A             10
E             15 (B+C+D)

select sum(case when fk_OrderType= 45175 then 1 else 0 end) OpenOrder,
  sum(case when fk_OrderType<> 45175 then 1 else 0 end) NoOpenOrder
from TrainingOrders