Task: Text to Code
Input (English): Step 1: For each row in Has_Allergy table, find corresponding rows in Allergy_Type table and in Student table.
Step 2: find Fname, Sex of the results of step 1 whose Allergy_Type's Allergy equals Cat and AllergyType equals Milk
Output (English): SELECT T3.Fname , T3.Sex FROM Allergy_Type AS T1 JOIN Has_Allergy AS T2 ON T1.Allergy = T2.Allergy JOIN Student AS T3 ON T2.StuID = T3.StuID WHERE T1.Allergy = "Cat" AND T1.AllergyType = "Milk"