SS&C Advent interview question

SQL, Perl, and Java questions.