What is the mean on-site ATMS that have off-site ATMs of 1567, and the total number of ATMs less than 4772?
CREATE TABLE table_name_20 (
    on_site_atms INTEGER,
    off_site_atms VARCHAR,
    total_atms VARCHAR
)
SELECT AVG(on_site_atms) FROM table_name_20 WHERE off_site_atms = 1567 AND total_atms < 4772
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 mean on-site ATMS that have off-site ATMs of 1567, and the total number of ATMs less than 4772? ### Input: CREATE TABLE table_name_20 (
    on_site_atms INTEGER,
    off_site_atms VARCHAR,
    total_atms VARCHAR
) ### Response: SELECT AVG(on_site_atms) FROM table_name_20 WHERE off_site_atms = 1567 AND total_atms < 4772