FIS Interview Question

queris on joints.. simple sql questions