<pre>
SELECT
"public".imsmaenum.enumvalue,Count("public".geopoint.geopoint_guid)
FROM
"public".imsmaenumINNER JOIN "public".geopoint ON "public".geopoint.pointtypeenum_guid = "public".imsmaenum.imsmaenum_guid
GROUP BY
"public".imsmaenum.enumvalue
ORDER BY
"public".imsmaenum.enumvalue ASC
</pre>