como utilizar un case en una subconsuta

[felipe12357]

Gracias por la ayuda, ya encontre la solucion!:

Código MySQL:

select idnumber,firstname,lastname,
MAX (case WHEN (questionattemptid in(select id from di082_question_attempts where questionid=74118 )) then round(fraction) end) as Q1,
MAX (case WHEN (questionattemptid in(select id from di082_question_attempts where questionid=74119 )) then round(fraction) end) as Q2,
MAX (case WHEN (questionattemptid in(select id from di082_question_attempts where questionid=74120 )) then round(fraction) end) as Q3,
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<=74147) and fraction is not null
group by di082_user.idnumber,di082_user.firstname, di082_user.lastname
order by lastname, firstname
 

Gracias