Surely you know enough about SQL to add the first name as a field ? It also seems to me like you have issues in part because of how your data is laid out, you should consider your database schema in terms of how you want to use it, so that it lends it self to the tasks at hand.

Are you working for an airline, or are we doing your school assignment for you ? Either way, it would be better if you engaged beyond assigning us tasks, and understood what was going on.