EY Interview Question

Sql query to count the distinct elements