
CREATE TABLE camera_lens (
	id INTEGER, 
	brand TEXT, 
	name TEXT, 
	focal_length_mm REAL, 
	max_aperture REAL, 
	PRIMARY KEY (id)
)


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


CREATE TABLE photos (
	id INTEGER, 
	camera_lens_id INTEGER, 
	mountain_id INTEGER, 
	color TEXT, 
	name TEXT, 
	PRIMARY KEY (id), 
	FOREIGN KEY(mountain_id) REFERENCES mountain (id), 
	FOREIGN KEY(camera_lens_id) REFERENCES camera_lens (id)
)

CREATE TABLE camera_lens (
	id INTEGER, 
	brand TEXT, 
	name TEXT, 
	focal_length_mm REAL, 
	max_aperture REAL, 
	PRIMARY KEY (id)
)

/*
2 rows from camera_lens table:
id	brand	name	focal_length_mm	max_aperture
1	Olympus	Olympus 15mm f/8.0 Body Cap	15.0	8.0
2	Olympus	Olympus M.Zuiko Digital ED 45mm f/1.8	45.0	1.8
*/


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

/*
2 rows from mountain table:
id	name	Height	Prominence	Range	Country
1	Abune Yosef / Guliba Amba	4260.0	1909.0	Lasta Massif	Ethiopia
2	Ioll / Yoll	4220.0	350.0	Kollo Massif	Ethiopia
*/


CREATE TABLE photos (
	id INTEGER, 
	camera_lens_id INTEGER, 
	mountain_id INTEGER, 
	color TEXT, 
	name TEXT, 
	PRIMARY KEY (id), 
	FOREIGN KEY(mountain_id) REFERENCES mountain (id), 
	FOREIGN KEY(camera_lens_id) REFERENCES camera_lens (id)
)

/*
2 rows from photos table:
id	camera_lens_id	mountain_id	color	name
1	1	20	RBG	monkey
2	10	2	RBG	rabbits
*/
What are the name, height and prominence of mountains which do not belong to the range 'Aberdare Range'?
SELECT name ,  height ,  prominence FROM mountain WHERE RANGE != 'Aberdare Range'
[{'name': 'Abune Yosef / Guliba Amba', 'Height': 4260.0, 'Prominence': 1909.0}, {'name': 'Ioll / Yoll', 'Height': 4220.0, 'Prominence': 350.0}, {'name': 'Bada', 'Height': 4195.0, 'Prominence': 1605.0}, {'name': 'Kaka / Kecha / Chiqe', 'Height': 4193.0, 'Prominence': 1215.0}, {'name': 'Jbel Toubkal', 'Height': 4167.0, 'Prominence': 3755.0}, {'name': 'Muhavura', 'Height': 4127.0, 'Prominence': 1530.0}, {'name': 'Hey / Hay', 'Height': 4125.0, 'Prominence': 660.0}, {'name': 'Guna', 'Height': 4120.0, 'Prominence': 1510.0}, {'name': 'Choqa / Choke / Birhan', 'Height': 4100.0, 'Prominence': 2225.0}, {'name': 'Ouanoukrim', 'Height': 4088.0, 'Prominence': 420.0}, {'name': 'Chilalo', 'Height': 4071.0, 'Prominence': 610.0}, {'name': 'Mount Cameroon', 'Height': 4070.0, 'Prominence': 3931.0}, {'name': 'Inatye', 'Height': 4070.0, 'Prominence': 500.0}, {'name': 'Ighil Mgoun', 'Height': 4068.0, 'Prominence': 1904.0}, {'name': 'Weshema / Wasema?', 'Height': 4030.0, 'Prominence': 420.0}, {'name': "Jebel n'Tarourt / Tifnout / Iferouane", 'Height': 3996.0, 'Prominence': 910.0}, {'name': 'Muggia', 'Height': 3950.0, 'Prominence': 500.0}, {'name': 'Dubbai', 'Height': 3941.0, 'Prominence': 1540.0}, {'name': 'Taska n’Zat', 'Height': 3912.0, 'Prominence': 460.0}, {'name': 'Aksouâl', 'Height': 3903.0, 'Prominence': 450.0}, {'name': 'Cimbia', 'Height': 3900.0, 'Prominence': 590.0}]