Task: Text to Code
Input (English): find the number of rows in artist table whose gender equals Male
Output (English): SELECT Count ( * ) FROM artist WHERE gender = "Male"