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;
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter