Hi @alidoustal
try:
Select classes.field , count(*) from tableName
UNNEST classes class
group by class;
For a live example, try following query with travel-sample:
select p, count(p) from travel-sample t UNNEST public_likes p where t.type = "hotel" group by p;