I dont understand this: “SELECT COUNT(*) as count, relation FROM tutorial”
It returns:
{
“results”: [
{
“count”: 6,
“relation”: “friend”
}
]
}
To me intuitively the query says: “get the count for everything (which is obviously just a single result)” and then get the relation… which should be multiple different results.
What’s the trick to understand this?