Below is the list of tables from the database along with their columns and datatype. Need to generate an accurate SQL query for the question.
Only use the columns present in the respective table. Only use the columns which are required to generate the SQL query. Only use table joins if required and not otherwise.

### Tables ###
TABLE: CREATE TABLE camera_lens (brand VARCHAR, name VARCHAR, max_aperture VARCHAR)

### Question ###
Find the brand and name for each camera lens, and sort in descending order of maximum aperture.

### Accurate SQL ###

SELECT brand, name FROM camera_lens ORDER BY max_aperture DESC