Database: mountain_photos
Question: What are the names of photos taken with the lens brand 'Sigma' or 'Olympus'?
SQL:
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'