SELECT count(DISTINCT brand) FROM camera_lens
How many different kinds of lens brands are there?
SELECT count ( DISTINCT brand ) FROM camera_lens
select count ( distinct brand ) from camera_lens
How many different kinds of lens brands are there ?