Table schema:
CREATE TABLE camera_lens (brand VARCHAR)

Question: How many different kinds of lens brands are there?
SQL: SELECT COUNT(DISTINCT brand) FROM camera_lens