Genea interview question

SQL - joins, rank etc Coding - string/array based