human
Schema:
roller_coaster (Roller_Coaster_ID, Name, Park, Country_ID, Length, Height, Speed, Opened, Status)
country (Country_ID, Name, Population, Area, Languages)
Please answer with SQL.
assistant
Sure, I understand.
human
HOW MANY COUNTRIES DO NOT HAVE AN ROLLER COASTER LONGER THAN 3000?
assistant
SELECT COUNT( * ) FROM country WHERE country_id NOT IN ( SELECT country_id FROM roller_coaster WHERE LENGTH > 3000 );
human
WHICH COUNTRY HAVE A ROLLER COASTER LONGER THAN 5000
assistant
SELECT T2.Name FROM roller_coaster AS T1 JOIN country AS T2 ON T1.Country_ID = T2.Country_ID WHERE T1.Length > 5000 ;