How long did it take for the rider of a Yamaha with a grid less than 8 and laps less than 23?
CREATE TABLE table_name_47 (
    time VARCHAR,
    laps VARCHAR,
    manufacturer VARCHAR,
    grid VARCHAR
)
SELECT time FROM table_name_47 WHERE manufacturer = "yamaha" AND grid < 8 AND laps < 23
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 long did it take for the rider of a Yamaha with a grid less than 8 and laps less than 23? ### Input: CREATE TABLE table_name_47 (
    time VARCHAR,
    laps VARCHAR,
    manufacturer VARCHAR,
    grid VARCHAR
) ### Response: SELECT time FROM table_name_47 WHERE manufacturer = "yamaha" AND grid < 8 AND laps < 23