Capgemini interview question

mysql joins and array codes 2 codes and one string code