
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 names of photos taken with the lens brand 'Sigma' or 'Olympus'?
SELECT T1.name FROM camera_lens AS T1 JOIN photos AS T2 ON T2.camera_lens_id  =  T1.id WHERE T1.brand  =  'Sigma' OR T1.brand  =  'Olympus'
[{'name': 'Olympus 15mm f/8.0 Body Cap'}, {'name': 'Sigma 19mm f2.8 EX DN'}, {'name': 'Sigma 19mm f2.8 EX DN'}, {'name': 'Olympus 15mm f/8.0 Body Cap'}, {'name': 'Sigma 19mm f2.8 EX DN'}, {'name': 'Sigma 19mm f2.8 EX DN'}]