como utilizar un case en una subconsuta

[Libras]

pues no entiendo el porque los between en un query, pero ok

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 BETWEEN 74118 AND 74120
AND fraction IS NOT NULL ORDER BY lastname, firstname
 

asi no te funciona???