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 shop ( Shop_ID int, Address text, Num_of_staff text, Score real, Open_Year text )
TABLE: CREATE TABLE happy_hour ( HH_ID int, Shop_ID int, Month text, Num_of_shaff_in_charge int )
TABLE: CREATE TABLE member ( Member_ID int, Name text, Membership_card text, Age int, Time_of_purchase int, Level_of_membership int, Address text )
TABLE: CREATE TABLE happy_hour_member ( HH_ID int, Member_ID int, Total_amount real )

### Question ###
Find the number of members living in each address. Show bar chart.

### Accurate SQL ###

SELECT Address, COUNT(*) FROM member GROUP BY Address