
CREATE TABLE country (
	"Country_ID" INTEGER, 
	"Name" TEXT, 
	"Population" INTEGER, 
	"Area" INTEGER, 
	"Languages" TEXT, 
	PRIMARY KEY ("Country_ID")
)


CREATE TABLE roller_coaster (
	"Roller_Coaster_ID" INTEGER, 
	"Name" TEXT, 
	"Park" TEXT, 
	"Country_ID" INTEGER, 
	"Length" REAL, 
	"Height" REAL, 
	"Speed" TEXT, 
	"Opened" TEXT, 
	"Status" TEXT, 
	PRIMARY KEY ("Roller_Coaster_ID"), 
	FOREIGN KEY("Country_ID") REFERENCES country ("Country_ID")
)

CREATE TABLE country (
	"Country_ID" INTEGER, 
	"Name" TEXT, 
	"Population" INTEGER, 
	"Area" INTEGER, 
	"Languages" TEXT, 
	PRIMARY KEY ("Country_ID")
)

/*
2 rows from country table:
Country_ID	Name	Population	Area	Languages
1	Austria	8206524	83871	German
2	Finland	5261008	338145	Finnish Swedish
*/


CREATE TABLE roller_coaster (
	"Roller_Coaster_ID" INTEGER, 
	"Name" TEXT, 
	"Park" TEXT, 
	"Country_ID" INTEGER, 
	"Length" REAL, 
	"Height" REAL, 
	"Speed" TEXT, 
	"Opened" TEXT, 
	"Status" TEXT, 
	PRIMARY KEY ("Roller_Coaster_ID"), 
	FOREIGN KEY("Country_ID") REFERENCES country ("Country_ID")
)

/*
2 rows from roller_coaster table:
Roller_Coaster_ID	Name	Park	Country_ID	Length	Height	Speed	Opened	Status
1	Boardwalk Bullet	Kemah Boardwalk	1	3236.0	96.0	51	August 31, 2007	Operating
2	Dauling Dragon	Happy Valley	1	3914.0	105.0	55	2012	Operating
*/
List the status shared by more than two roller coaster.
SELECT Status FROM roller_coaster GROUP BY Status HAVING COUNT(*)  >  2
[{'Status': 'Operating'}]