CREATE TABLE table_name_25 (average_parish_size INT, _percentage_of_adherents VARCHAR, regular_attendees VARCHAR)

What is the lowest average parish size with 47.2% of adherents and 4,936 regular attendees?
SELECT MIN(average_parish_size) FROM table_name_25 WHERE _percentage_of_adherents = "47.2%" AND regular_attendees > 4 OFFSET 936
SELECT MIN("average_parish_size") FROM "table_name_25" WHERE "47.2%" = "_percentage_of_adherents" AND "regular_attendees" > 4 OFFSET 936