WITH table1 AS ( SELECT p.device_id, q.question_id, CASE WHEN p.result = 'right' THEN 1 ELSE 0 END AS result, q.difficult_level FROM question_detail q RIGHT JOIN question_practice_detail p ON q.qu...