Count where two or more columns in a row are over a certain value [basketball, double double, triple double]
Don't know if this is the best way. I first did a select to find out if a stat is double digit and assign it a 1 if it is. Summed all those up to find out total number of double digits per game. From there just sum up all the doubles and triples. Seems to work   

select a.player_id, 
a.team, 
sum(case when a.doubles = 2 then 1 else 0 end) as doubleDoubles, 
sum(case when a.doubles = 3 then 1 else 0 end) as tripleDoubles
from
(select *, 
(case when points &gt; 9 then 1 else 0 end) +
(case when rebounds &gt; 9 then 1 else 0 end) +
(case when assists &gt; 9 then 1 else 0 end) +
(case when steals &gt; 9 then 1 else 0 end) +
(case when blocks &gt; 9 then 1 else 0  end) as Doubles
from PlayerGameStats) a
group by a.player_id, a.team