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