What rank was caerphilly with a Swing smaller than 6.92?
CREATE TABLE table_10837 (
    "Rank" real,
    "Constituency" text,
    "Winning party 2007" text,
    "Swing to gain" real,
    "PC's place 2007" text,
    "Result" text
)
SELECT COUNT("Rank") FROM table_10837 WHERE "Swing to gain" < '6.92' AND "Constituency" = 'caerphilly'
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: What rank was caerphilly with a Swing smaller than 6.92? ### Input: CREATE TABLE table_10837 (
    "Rank" real,
    "Constituency" text,
    "Winning party 2007" text,
    "Swing to gain" real,
    "PC's place 2007" text,
    "Result" text
) ### Response: SELECT COUNT("Rank") FROM table_10837 WHERE "Swing to gain" < '6.92' AND "Constituency" = 'caerphilly'