
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
*/
Show the name and prominence of the mountains whose picture is not taken by a lens of brand 'Sigma'.
SELECT name ,  prominence FROM mountain EXCEPT SELECT T1.name ,  T1.prominence FROM mountain AS T1 JOIN photos AS T2 ON T1.id  =  T2.mountain_id JOIN camera_lens AS T3 ON T2.camera_lens_id  =  T3.id WHERE T3.brand  =  'Sigma'
[{'name': 'Aksouâl', 'Prominence': 450.0}, {'name': 'Bada', 'Prominence': 1605.0}, {'name': 'Chilalo', 'Prominence': 610.0}, {'name': 'Choqa / Choke / Birhan', 'Prominence': 2225.0}, {'name': 'Cimbia', 'Prominence': 590.0}, {'name': 'Dubbai', 'Prominence': 1540.0}, {'name': 'Guna', 'Prominence': 1510.0}, {'name': 'Hey / Hay', 'Prominence': 660.0}, {'name': 'Inatye', 'Prominence': 500.0}, {'name': 'Jbel Toubkal', 'Prominence': 3755.0}, {'name': "Jebel n'Tarourt / Tifnout / Iferouane", 'Prominence': 910.0}, {'name': 'Kaka / Kecha / Chiqe', 'Prominence': 1215.0}, {'name': 'Mount Cameroon', 'Prominence': 3931.0}, {'name': 'Mount Kinangop', 'Prominence': 530.0}, {'name': 'Muggia', 'Prominence': 500.0}, {'name': 'Muhavura', 'Prominence': 1530.0}, {'name': 'Oldoinyo Lesatima', 'Prominence': 2081.0}, {'name': 'Ouanoukrim', 'Prominence': 420.0}, {'name': 'Weshema / Wasema?', 'Prominence': 420.0}]