CREATE TABLE table_37661 ("Name" CLOB, "Period" CLOB, "Starts" FLOAT, "Wins" FLOAT, "Losses" FLOAT, "Ties" FLOAT, "Win %" FLOAT)

Which Wins have a Win % smaller than 0.8270000000000001, and a Name of rick mirer, and Ties smaller than 1?
SELECT SUM("Wins") FROM table_37661 WHERE "Win %" < '0.8270000000000001' AND "Name" = 'rick mirer' AND "Ties" < '1'
SELECT SUM("Wins") FROM "table_37661" WHERE "Name" = 'rick mirer' AND "Ties" < '1' AND "Win %" < '0.8270000000000001'