ST_NumGeometries(gc)

Returns the number of geometries in the GeometryCollection value gc.

ST_NumGeometries() handles its arguments as described in the
introduction to this section.

URL: https://dev.mysql.com/doc/refman/8.4/en/gis-geometrycollection-property-functions.html

