CREATE TABLE table_name_20 (on_site_atms NUMBER, off_site_atms VARCHAR2, total_atms VARCHAR2)

What is the mean on-site ATMS that have off-site ATMs of 1567, and the total number of ATMs less than 4772?
SELECT AVG(on_site_atms) FROM table_name_20 WHERE off_site_atms = 1567 AND total_atms < 4772
SELECT AVG("on_site_atms") FROM "table_name_20" WHERE "off_site_atms" = 1567 AND "total_atms" < 4772