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 member ( member_id number, name text, country text, college_id number )
TABLE: CREATE TABLE round ( round_id number, member_id number, decoration_theme text, rank_in_round number )
TABLE: CREATE TABLE college ( college_id number, name text, leader_name text, college_location text )

### Question ###
List the names of members in ascending alphabetical order.

### Accurate SQL ###

SELECT name FROM member ORDER BY name