This technical problem deals with writing a SQL query to find the number of distinct values in each column of a table. The input is a table with two columns, and the output is the number of distinct values in each column.
The solution above is optimal because it uses the COUNT function with the DISTINCT keyword. This will count the number of unique values in each column.
Evaluated at: 2023-01-29 02:15:29