ORDERS
order_id varchar
customer_id int
order_datetime timestamp
item_id varchar
item_price decimal
item_quantity int
primary key (order_id, item_id)

ITEMS
item_id varchar(10)
item_category varchar(20)
primary key (item_id)

ADDRESSES
customer_id int
start_date timestamp
end_date timestamp
zip_code varchar
city varchar
state varchar
country varchar
primary key (customer_id, start_date)

Question :For customers that currently live in Seattle, what is the most common city they lived in previously?

can some one help with the solution