How many different lens are there? | Did  you  mean  the  different  brand of lens are there | No, I meant the total number of lenses
SELECT  count ( * )   from  camera_lens
total number of lenses refers to COUNT(*);