[sql]SELECT COUNT(*) AS anz, kategorie FROM <table> GROUP BY kategorie ORDER BY anz LIMIT 10[/sql]
[sql]SELECT COUNT(*) AS anz, typ FROM <table> GROUP BY typ ORDER BY anz LIMIT 10[/sql]
[sql]SELECT COUNT(*) AS anz, kategorie, typ FROM <table> GROUP BY kategorie, typ ORDER BY anz LIMIT 10[/sql]

(ungetestet)