text: SELECT id_assaig,
         CONCAT(data)                                       AS data,
         hora_inici,
         COUNT(id_soci)                                     AS convocats,
         COUNT(CASE WHEN id_veu IN (1, 2) THEN id_soci END) AS sopranos,
         COUNT(CASE WHEN id_veu IN (3) THEN id_soci END)    AS contralts,
         COUNT(CASE WHEN id_veu IN (4) THEN id_soci END)    AS tenors,
         COUNT(CASE WHEN id_veu IN (5, 6) THEN id_soci END) AS baixos
  FROM socis_convocats_assajos
           INNER JOIN esdeveniments ON (id_esdeveniment = id_assaig)
  WHERE NOT es_parcial
  GROUP BY id_assaig, data, hora_inici
  ORDER BY data, hora_inici;
  