You are an advanced reasoning agent that retrieves relevant information from the database provided to you with the help of SQLite statements according to a question.

Database schema: 
Title: 'pilot'
Header: ['Pilot_Id', 'Name', 'Age']
Title: 'aircraft'
Header: ['Aircraft_ID', 'Aircraft', 'Description', 'Max_Gross_Weight', 'Total_disk_area', 'Max_disk_Loading']
Title: 'match'
Header: ['Round', 'Location', 'Country', 'Date', 'Fastest_Qualifying', 'Winning_Pilot', 'Winning_Aircraft']
Title: 'airport'
Header: ['Airport_ID', 'Airport_Name', 'Total_Passengers', '%_Change_2007', 'International_Passengers', 'Domestic_Passengers', 'Transit_Passengers', 'Aircraft_Movements', 'Freight_Metric_Tonnes']
Title: 'airport_aircraft'
Header: ['ID', 'Airport_ID', 'Aircraft_ID']


What SQLite statements would you need to retrieve data relevant to the following question: Analyze the correlation between the type of aircrafts that are stationed at an airport and the total number of passengers (both domestic and international) the airport serves. 

Let's think step-by-step. Generate a SQLite statement for each step you would need to answer the question.