Genea Interview Question

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