Please check if student 124 is disabled male.
if student name appear in disabled then student is disabled and vice versa; if student name appear in male then student is male and vice versa
SELECT IIF(T2.name IS NULL, 'female', 'male') FROM male AS T1 LEFT JOIN disabled AS T2 ON T1.name = T2.name WHERE T1.name = 'student124'