What was the lowest rank by average of a couple who had an average of 23 and a total of 115?
CREATE TABLE table_name_99 (
    rank_by_average INTEGER,
    average VARCHAR,
    total VARCHAR
)
SELECT MIN(rank_by_average) FROM table_name_99 WHERE average = 23 AND total = 115
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 was the lowest rank by average of a couple who had an average of 23 and a total of 115? ### Input: CREATE TABLE table_name_99 (
    rank_by_average INTEGER,
    average VARCHAR,
    total VARCHAR
) ### Response: SELECT MIN(rank_by_average) FROM table_name_99 WHERE average = 23 AND total = 115