Table: banking_in_india
Columns: bank_type
number_of_branches
on_site_atms
off_site_atms
total_atms

Question: What is the total ATMs with off-site ATMs greater than 3672, and less than 1685 as the number of branches?
SQL: SELECT COUNT("total_atms") FROM banking_in_india WHERE "off_site_atms" > 3672 AND "number_of_branches" < 1685

Question: What is the total number of branches when the on-site ATMS is 1548, and the off-site ATMs is bigger than 3672?
SQL: SELECT SUM("number_of_branches") FROM banking_in_india WHERE "on_site_atms" = 1548 AND "off_site_atms" > 3672

Question: What is the minimum total ATMs with new private sector banks as the bank type, and the on-site ATMs are greater than 1883?
SQL: SELECT MIN("total_atms") FROM banking_in_india WHERE "bank_type" = 'new private sector banks' AND "on_site_atms" > 1883

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

Question: With foreign banks as the bank type, and on-site ATMS less than 218, what is the average off-site ATMs?
SQL: SELECT AVG("off_site_atms") FROM banking_in_india WHERE "bank_type" = 'foreign banks' AND "on_site_atms" < 218