FIS interview question

queris on joints.. simple sql questions