COUNT(DISTINCT field_name) analog

[gych76]

Do you have analog of SQL query?
SELECT field1 COUNT(DISTINCT field2)
FROM table_name
GROUP BY field1;