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
What are name of all the roller coasters?
assistant
SELECT name FROM Roller_coaster;
human
Give me their length.
assistant
SELECT name , length FROM Roller_coaster;
human
Show me the roller coasters that are longer than 3000.
assistant
SELECT name , length FROM Roller_coaster WHERE length > 3000;
human
How many countries do not have any of them?
assistant
SELECT COUNT( * ) FROM country WHERE country_id NOT IN ( SELECT country_id FROM roller_coaster WHERE LENGTH > 3000 ) ;