Task: Text to Code
Input (English): How many countries do not have an roller coaster longer than 3000?
Output (English): SELECT count(*) FROM country WHERE country_id NOT IN ( SELECT country_id FROM roller_coaster WHERE LENGTH  >  3000 )