SELECT count(*) FROM country WHERE country_id NOT IN ( SELECT country_id FROM roller_coaster WHERE LENGTH  >  3000 )
How many countries do not have an roller coaster longer than 3000?
SELECT count ( * ) FROM country WHERE country_id NOT IN ( SELECT country_id FROM roller_coaster WHERE LENGTH > 3000 )
select count ( * ) from country where country_id not in ( select country_id from roller_coaster where length > value )
How many countries do not have an roller coaster longer than 3000 ?