Task: Text to Code
Input (English): find the number of rows in classroom table whose capacity greater than 50 and capacity less than Lamberton
Output (English): SELECT Count ( * ) FROM classroom WHERE capacity > "Lamberton" AND capacity < 50