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
How many different lens are there? | Did you mean the different brand of lens are there | No, I meant the total number of lenses
assistant
SELECT COUNT( * ) FROM camera_lens;
human
Can you please list the ones that contain substring 'Digital' in their names? | The names of the camera lens that contain substring 'Digital' in their names are Olympus M.Zuiko Digital ED 45mm f/1.8,
Olympus M.Zuiko Digital ED 75mm f/1.8 | Can you please also include their id?
assistant
SELECT name , id FROM camera_lens WHERE name LIKE "%Digital%" ;