This query will return all players from 1871 - 2014 who had at least 7000 AB's during their career. The list is sorted by the lowest->strikeout percentages (SOPERC)

lahman_historical_strikeoutpercentage.sql

#using the Lahman Baseball Database 
SELECT 
    CONCAT(YEAR(m.debut), ' - ', YEAR(m.finalGame)) AS YEARSPLAYED,
    CONCAT(m.nameFirst, ' ', m.nameLast) AS NAME,
    SUM(b.AB) AS AB,
    ROUND(SUM(b.so) / SUM(b.AB + b.BB + b.HBP + COALESCE(b.SF, 0)) * 100, 2) AS SOPERC

FROM
    Batting b,
    Master m

WHERE
    b.playerID = m.playerID
    
GROUP BY b.playerID HAVING AB > 7000
	AND YEARSPLAYED <> 'null'
    
ORDER BY SOPERC ASC;