Posts by João Filipe • 21 points
1 post
-
2
votes1
answer905
viewsQ: ERROR #1111 - Invalid use of group Function (SUM | COUNT)
This query gives me the total attendance of two parliamentary groups (e.g: PS, PSD) between two dates: SELECT DISTINCT a.partido, (SELECT COUNT(presencas.assiduidade) FROM presencas, reunioes WHERE…