Wire Samples
SELECT pitch_type, COUNT(*) as count, ROUND(AVG(release_speed)::numeric, 1) as avg_velo FROM pitch_data GROUP BY pitch_type ORDER BY count DESC LIMIT 15
SELECT player_name, COUNT(*) as pitches, ROUND(AVG(release_speed)::numeric, 1) as avg_velo FROM pitch_data WHERE release_speed > 100 GROUP BY player_name ORDER BY pitches DESC LIMIT 20
SELECT player_name, ROUND(AVG(launch_speed)::numeric, 1) as avg_exit_velo, COUNT(*) as batted_balls FROM pitch_data WHERE launch_speed IS NOT NULL GROUP BY player_name HAVING COUNT(*) > 100 ORDER BY avg_exit_velo DESC LIMIT 20
SELECT * FROM pitch_data LIMIT 10