CREATE TABLE camera_lens (id DECIMAL, brand TEXT, name TEXT, focal_length_mm DECIMAL, max_aperture DECIMAL)
CREATE TABLE mountain (id DECIMAL, name TEXT, height DECIMAL, prominence DECIMAL, range TEXT, country TEXT)
CREATE TABLE photos (id DECIMAL, camera_lens_id DECIMAL, mountain_id DECIMAL, color TEXT, name TEXT)

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'
SELECT "T1"."name" FROM "camera_lens" AS "T1" JOIN "photos" AS "T2" ON "T1"."id" = "T2"."camera_lens_id" WHERE "T1"."brand" = 'Olympus' OR "T1"."brand" = 'Sigma'