What is the highest number of not usable satellites when there are more than 0 launch failures, less than 30 retired, and the block is I?
CREATE TABLE table_name_30 (
    not_usable INTEGER,
    block VARCHAR,
    launch_failures VARCHAR,
    retired VARCHAR
)
SELECT MAX(not_usable) FROM table_name_30 WHERE launch_failures > 0 AND retired < 30 AND block = "block i"
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 is the highest number of not usable satellites when there are more than 0 launch failures, less than 30 retired, and the block is I? ### Input: CREATE TABLE table_name_30 (
    not_usable INTEGER,
    block VARCHAR,
    launch_failures VARCHAR,
    retired VARCHAR
) ### Response: SELECT MAX(not_usable) FROM table_name_30 WHERE launch_failures > 0 AND retired < 30 AND block = "block i"