1 2 3 4 5 6
use plato; SELECT key , COUNT(*) AS cnt , COUNT(DISTINCT value) AS uniq FROM Input GROUP BY key