Oracle, SQL Server, Postgres, DB2 - the list goes on.<BR><BR>The reality is you have to restructure your query. A CTE isn't necessary, but will likely make the query more readable.

Now what I want to know is for each question in the quiz, how often they were answered correctly on the first attempt, how often they were answered correctly on the last attempt (of course when ...