SELECT count(Difficulty), min(Time), max(Time), avg(Time), sum(NumberRight), sum(NumberWrong) FROM (SELECT * FROM IntegerModeData WHERE Difficulty=rowNumber AS CSFIVE FREAKING TIMES! The other answer I was thinking of would be to make a table with just the difficultyNumber and the difficultyName, and use a JOIN. The second option seems more tempting, but I was wanting to know which one would YOU choose and why?
Oh, and does a JOIN search a whole table for a match between the two tables?
This post has been edited by IceHot: 18 May 2013 - 03:19 PM