What is the gender of student1000?
student name appear in Male table means student is a male, student does not appear in Male table means student is a female
SELECT IIF(T.result = 0, 'female', 'male') AS re FROM ( SELECT COUNT(name) AS result FROM male WHERE name = 'studenT1000' ) T