what is the brand name of id  2 ? | Did you mean the brand or name of the camera lens with ID 2? | yes
SELECT brand FROM camera_lens where id  =  2
brand name of an item with a specific ID refers to selecting the brand column from the table where the id column matches the specified ID value;