How many times was the r 4?
CREATE TABLE table_29424 (
    "R" real,
    "Player" text,
    "Position" text,
    "The Championship" real,
    "FA Cup" real,
    "League Cup" real,
    "Total" real
)
SELECT COUNT("League Cup") FROM table_29424 WHERE "R" = '4'
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: How many times was the r 4? ### Input: CREATE TABLE table_29424 (
    "R" real,
    "Player" text,
    "Position" text,
    "The Championship" real,
    "FA Cup" real,
    "League Cup" real,
    "Total" real
) ### Response: SELECT COUNT("League Cup") FROM table_29424 WHERE "R" = '4'