how many times

[slimdave]

Select
   Sum(Decode(WN1,5,1,0)+
       Decode(WN2,5,1,0)+
       Decode(WN3,5,1,0))
From
   TableA;

I'm not clear what you want from the second part.