Totals Summary

I have a list of wedding guests whose reply is one of 'yes','no','not yet repied'. I would like to make a totals summary to see how may. In SQL this would be something like "SELECT reply,count(*) FROM guests GROUP BY reply;" Is there a way to do this in Zoho Creator?
afitting