SELECT MAX(eligible_countries)
FROM (
SELECT f.NAME, COUNT(c.ID) AS eligible_countries
FROM FAMILIES f
JOIN COUNTRIES c ON f.FAMILY_SIZE BETWEEN c.MIN_SIZE AND c.MAX_SIZE
GROUP BY f.ID, f.NAME
) AS family_counts;
SELECT MAX(eligible_countries)
FROM (
SELECT f.NAME, COUNT(c.ID) AS eligible_countries
FROM FAMILIES f
JOIN COUNTRIES c ON f.FAMILY_SIZE BETWEEN c.MIN_SIZE AND c.MAX_SIZE
GROUP BY f.ID, f.NAME
) AS family_counts;