IQVIA Interview Question

Sql query on groups and koins