Natixis interview question

some intermediate sql queries and basic computer programming