
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
*/
What are the names of the climbers, ordered by points descending?
SELECT Name FROM climber ORDER BY Points DESC
[{'Name': 'Klaus Enders'}, {'Name': 'Siegfried Schauzu'}, {'Name': 'Hans Luthringhauser'}, {'Name': 'Jean Claude Castella'}, {'Name': 'Horst Owesle'}, {'Name': 'Georg Auerbacher'}, {'Name': 'Arseneus Butscher'}, {'Name': 'Charlie Freedman'}, {'Name': 'L Currie'}, {'Name': 'Mick Horsepole'}]