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 are the brand and name of each camera lens?
assistant
SELECT brand , name FROM camera_lens;
human
Sort the results in descending order of the lens' maximum aperture.
assistant
SELECT brand , name FROM camera_lens ORDER BY max_aperture DESC ;