id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
28296	Add support for aggregation through subqueries	László Károlyi	B Martsberger	"Hey guys,

after having spent a couple of hours figuring out why a subquery annotated with `Count` fails, I came to the conclusion that `Count` in a query causes `GROUP BY` clauses added to it, which in turn renders the SQL subquery useless.

Please investigate this example which I just added to Stack Overflow as a resolution, and see what I'm talking about:

https://stackoverflow.com/a/44474268/1067833
"	New feature	assigned	Database layer (models, ORM)	dev	Normal			Simon Charette Evgeny Arshinov şuayip üzülmez Ionel Cristian Mărieș Balazs Endresz	Accepted	1	0	0	1	0	0