SELECT winner, subject, subject IN('Physics', 'Chemistry')WHERE yr=1984 WHENsubject IN ('Physics', 'Chemistry') = 0 THEN subject IN ('Physics', 'Chemistry')
WHEN s
select s.student_name where s.student_id=m.student_id and su.subject_id=m.subject_id and max(m.value)in
(select value from mark where lower(su.subject_name)='software engineering