FDM Group interview question

basic SQL questions, join , key