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
Show all the mountains.
assistant
SELECT * FROM mountain;
human
Which mountains do not belong to the range 'Aberdare Range'?
assistant
SELECT * FROM mountain WHERE range != 'Aberdare Range';
human
What are those mountains' name, height and prominence?
assistant
SELECT name , height , prominence FROM mountain WHERE range != "Aberdare Range" ;