计数功能的使用会在Elasticsearch中产生错误

Question

使用Elasticsearch 7.*，使用SQL计数函数的使用会产生错误。 请指导这里可能有什么问题。

#Working:
GET _sql?format=txt
{
 "query": "select Id, Timestamp as StartTime, TransactionName as Service from \"com-prod-audit\" where TransactionName IN('Send') order by Timestamp desc LIMIT 10"
}

#####Updated:
GET _sql?format=txt
{
 "query": "select Id, Timestamp as StartTime, TransactionName as Service, COUNT(TransactionName) as count from \"com-prod-audit\" where TransactionName IN('Send') group by Id LIMIT 10"
}

#Error:
"type" : "verification_exception",
"reason" : "Found 1 problem\nline 1:24: Cannot use non-grouped columns [Timestamp, TransactionName], expected [Id]"
  },
  "status" : 400