Show the names of pilots and the number of records they have.
SELECT T2.Pilot_name ,  COUNT(*) FROM pilot_record AS T1 JOIN pilot AS T2 ON T1.pilot_ID  =  T2.pilot_ID GROUP BY T2.Pilot_name
SELECT T2.Pilot_name ,  COUNT(*) FROM pilot_record AS T1 JOIN pilot AS T2 ON T1.pilot_ID  =  T2.pilot_ID GROUP BY T2.Pilot_name
[{'Pilot_name': 'Charles Oakley', 'COUNT(*)': 1}, {'Pilot_name': "Dan O'Sullivan", 'COUNT(*)': 1}, {'Pilot_name': "Jermaine O'Neal", 'COUNT(*)': 1}, {'Pilot_name': "Patrick O'Bryant", 'COUNT(*)': 3}]