Task: Text to Code
Input (English): Step 1: For each row in list table, find the corresponding rows in teachers table.
Step 2: find the number of rows in the results of step 1 whose FirstName equals MADLOCK and FirstName equals RAY
Output (English): SELECT Count ( * ) FROM list AS T1 JOIN teachers AS T2 WHERE T1.FirstName = "MADLOCK" AND T2.FirstName = "RAY"