logre que me genere so campos num y nums de cada usuario pero como podria sumar esos campos?
Código SQL:
Ver originalSELECT h.id, (SELECT COUNT(a.ticket_id )AS num
FROM allocations a
JOIN tickets b ON a.ticket_id = b.id
WHERE a.ing_id = h.id
AND b.status_id = 1) AS num,
(SELECT COUNT(a.ticket_id )AS nums
FROM allocations a
JOIN tickets b ON a.ticket_id = b.id
WHERE a.ing_id = h.id
AND b.status_id = 2) AS nums
FROM users h
WHERE h.rol_id = 2 GROUP BY h.id ORDER BY num
lo que me arroja
id num nums
1 2 3
2 1 2