How to find No. of Records present in Each AMP for a given Table through SQL?

SEL HASHAMP(HASHBUCKET(HASHROW(PRIMARY_INDEX_COLUMNS)))  

AS AMP_NO , COUNT(*)

FROM DATABASENAME.TABLE_NAME

GROUP BY 1;