[reihane ce]

hello, i created nodes in java az groups and users.i want to write a query that shows the number of persons each group.
my users have the "sex" property.i want to show the number of Male and Female but i can only show one of them.neo4j doesn't have GROUPBY.

ExecutionEngine engine = new ExecutionEngine( graphDb );
Map<String, Object> params=new HashMap<String, Object>();
params.put("query", "name:*");
ExecutionResult result = engine.execute( "start n=node:groups({query}) match n<-[:Members_In]-x where x.Sex='Male' return n.name, count(x)"

n is group node.
x is the members of each group.how can i count the number of females and males together?
Thanks.