Amdocs Interview Question

SQL from distinct with different cases of letters.