como utilizar un case en una subconsuta

[Libras]

Código SQL:

SELECT idnumber,firstname,lastname,
CASE WHEN questionattemptid=74118 THEN fraction END AS nota1,
CASE WHEN questionattemptid=74119 THEN fraction END AS nota2,
CASE WHEN questionattemptid=74120 THEN fraction END AS nota3
FROM 
di082_question_attempt_steps 
INNER JOIN di082_user ON di082_user.id=di082_question_attempt_steps.userid
WHERE questionattemptid IN
(SELECT id FROM di082_question_attempts WHERE questionid>=74118 AND questionid<=74120) AND fraction IS NOT NULL ORDER BY lastname, firstname
 

y asi regresa o que quieres???