What's the highest Rank for the County of Offaly, the Player of Mark Corrigan, and the Total that is smaller than 8?
CREATE TABLE table_name_49 (
    rank INTEGER,
    total VARCHAR,
    county VARCHAR,
    player VARCHAR
)
SELECT MAX(rank) FROM table_name_49 WHERE county = "offaly" AND player = "mark corrigan" AND total < 8
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's the highest Rank for the County of Offaly, the Player of Mark Corrigan, and the Total that is smaller than 8? ### Input: CREATE TABLE table_name_49 (
    rank INTEGER,
    total VARCHAR,
    county VARCHAR,
    player VARCHAR
) ### Response: SELECT MAX(rank) FROM table_name_49 WHERE county = "offaly" AND player = "mark corrigan" AND total < 8