
CREATE TABLE climber (
	"Climber_ID" INTEGER, 
	"Name" TEXT, 
	"Country" TEXT, 
	"Time" TEXT, 
	"Points" REAL, 
	"Mountain_ID" INTEGER, 
	PRIMARY KEY ("Climber_ID"), 
	FOREIGN KEY("Mountain_ID") REFERENCES mountain ("Mountain_ID")
)


CREATE TABLE mountain (
	"Mountain_ID" INTEGER, 
	"Name" TEXT, 
	"Height" REAL, 
	"Prominence" REAL, 
	"Range" TEXT, 
	"Country" TEXT, 
	PRIMARY KEY ("Mountain_ID")
)

CREATE TABLE climber (
	"Climber_ID" INTEGER, 
	"Name" TEXT, 
	"Country" TEXT, 
	"Time" TEXT, 
	"Points" REAL, 
	"Mountain_ID" INTEGER, 
	PRIMARY KEY ("Climber_ID"), 
	FOREIGN KEY("Mountain_ID") REFERENCES mountain ("Mountain_ID")
)

/*
2 rows from climber table:
Climber_ID	Name	Country	Time	Points	Mountain_ID
1	Klaus Enders	West Germany	1:13.05.6	15.0	1
2	Siegfried Schauzu	West Germany	1:14.56.4	12.0	1
*/


CREATE TABLE mountain (
	"Mountain_ID" INTEGER, 
	"Name" TEXT, 
	"Height" REAL, 
	"Prominence" REAL, 
	"Range" TEXT, 
	"Country" TEXT, 
	PRIMARY KEY ("Mountain_ID")
)

/*
2 rows from mountain table:
Mountain_ID	Name	Height	Prominence	Range	Country
1	Kibo (Uhuru Pk)	5895.0	5885.0	Kilimanjaro	Tanzania
2	Mount Kenya (Batian)	5199.0	3825.0	Mount Kenya	Kenya
*/
Give the names of mountains in alphabetical order.
SELECT Name FROM mountain ORDER BY Name ASC
[{'Name': 'Duwoni / Mt Speke (Vittorio Emanuele Pk)'}, {'Name': 'Kibo (Uhuru Pk)'}, {'Name': 'Mawenzi (Hans Meyer Pk)'}, {'Name': 'Mount Kenya (Batian)'}, {'Name': 'Mount Kenya (Lenana)'}, {'Name': 'Ngaliema / Mt Stanley (Margherita Pk)'}, {'Name': 'Ngaliema / Mt Stanley (Savoia Pk)'}]