user: ### NOW ANSWER:
Question: Which Wins have a Win % smaller than 0.8270000000000001, and a Name of rick mirer, and Ties smaller than 1?
Columns: ['Name', 'Period', 'Starts', 'Wins', 'Losses', 'Ties', 'Win %']
Types: ['text', 'text', 'real', 'real', 'real', 'real', 'real']
Sample row: ['Ron Powlus', '1994–1997', 46.0, 29.0, 16.0, 1.0, 0.641]
SQL:

assistant: SELECT SUM("Wins") FROM "Table" WHERE "Win %" < 0.8270000000000001 AND "Name" = 'rick mirer' AND "Ties" < 1.0;