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 people ( People_ID int, District text, Name text, Party text, Age int )
TABLE: CREATE TABLE debate_people ( Debate_ID int, Affirmative int, Negative int, If_Affirmative_Win bool )
TABLE: CREATE TABLE debate ( Debate_ID int, Date text, Venue text, Num_of_Audience int )

### Question ###
A bar chart showing the number of debates in each venue for those on the affirmative side, and rank by the the number of venue in asc.

### Accurate SQL ###

SELECT Venue, COUNT(Venue) FROM debate_people AS T1 JOIN debate AS T2 ON T1.Debate_ID = T2.Debate_ID JOIN people AS T3 ON T1.Affirmative = T3.People_ID GROUP BY Venue ORDER BY COUNT(Venue)