Task: Text to Code
Input (English): find each value of Pilot_name in pilot table along with the number of the corresponding rows to each value
Output (English): SELECT Pilot_name , Count ( * ) FROM pilot GROUP BY Pilot_name