Task: Text to Code
Input (English): SQL: SELECT Count ( * ) FROM Physician WHERE Name = "John Dorian"
Feedback: Find number of rows of prescribes table whose corresponding Physician's name equals John Dorian
Output (English): SELECT count(T1.SSN) FROM patient AS T1 JOIN prescribes AS T2 ON T1.SSN  =  T2.patient JOIN physician AS T3 ON T2.physician  =  T3.employeeid WHERE T3.name = "John Dorian"