...
Query: The query must contain all the columns that you want to retrieve.
Column Alias: Explained by the use of When using an alias for the main column: city_id as 'id'. If no alias then it must be the same as the column name.
And here is the result :
Complex configuration
...