human
Schema:
mountain (id, name, Height, Prominence, Range, Country)
camera_lens (id, brand, name, focal_length_mm, max_aperture)
photos (id, camera_lens_id, mountain_id, color, name)
Please answer with SQL.
assistant
Sure, I understand.
human
what is the brand name of id 2 ? | Did you mean the brand or name of the camera lens with ID 2? | yes
assistant
SELECT brand FROM camera_lens WHERE id = 2;
human
what is color of mountain id no. 20 ?
assistant
SELECT DISTINCT ( color ) FROM photos WHERE mountain_id = 20 ;