CREATE TABLE table_23167 ("RPM" FLOAT, "Standard HP" CLOB, "Standard torque  ( lb/ft ) " CLOB, "Standard speed  ( 6th gear ) " CLOB, "Modified speed  ( 6th gear ) " FLOAT, "Modified HP" CLOB, "Modified torque  ( lb/ft ) " CLOB)

when the max speed for modified speed (6th gear) where standard speed (6th gear) is 98
SELECT MAX("Modified speed (6th gear)") FROM table_23167 WHERE "Standard speed (6th gear)" = '98'
SELECT MAX("Modified speed (6th gear)") FROM "table_23167" WHERE "Standard speed (6th gear)" = '98'