Which Wins have a Win % smaller than 0.8270000000000001, and a Name of rick mirer, and Ties smaller than 1?
CREATE TABLE table_37661 (
    "Name" text,
    "Period" text,
    "Starts" real,
    "Wins" real,
    "Losses" real,
    "Ties" real,
    "Win %" real
)
SELECT SUM("Wins") FROM table_37661 WHERE "Win %" < '0.8270000000000001' AND "Name" = 'rick mirer' AND "Ties" < '1'
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: Which Wins have a Win % smaller than 0.8270000000000001, and a Name of rick mirer, and Ties smaller than 1? ### Input: CREATE TABLE table_37661 (
    "Name" text,
    "Period" text,
    "Starts" real,
    "Wins" real,
    "Losses" real,
    "Ties" real,
    "Win %" real
) ### Response: SELECT SUM("Wins") FROM table_37661 WHERE "Win %" < '0.8270000000000001' AND "Name" = 'rick mirer' AND "Ties" < '1'