Morgan Stanley interview question

I was asked a technical question about how I would use data from two columns to create a derived field using SQL