Estou tentando executar esse query, gostaria de agrupar apenas pelo legal_name
Acredito que bastaria remover os outros campos (tax_identifier e cipher_schema) do select e do group by. Mas a questão é, esses campos não serão necessários no retorno dessa consulta não?
Teste
Pesquisei e li essa dica de usar MAX, mas não tenho certeza se funciona:
SELECT
MAX(tax_identifier),
legal_name ,
SUM(cipher_schema."Transaction".amount),
MAX(cipher_schema."Transaction".transaction_date)
FROM
accent_schema."Person"
INNER JOIN accent_schema."PersonRelation"
ON accent_schema."Person".id = accent_schema."PersonRelation".person_child
INNER JOIN cipher_schema."Person"
ON cipher_schema."Person".id = accent_schema."PersonRelation".person_child
INNER JOIN cipher_schema."Account"
ON cipher_schema."Account".organization_person_id = accent_schema."PersonRelation".person_parent
INNER JOIN cipher_schema."Transaction"
ON cipher_schema."Transaction".account_id = cipher_schema."Account".id
WHERE
person_parent = 'a90ca3e4-9bc2-4043-a5ec-f7c6a291558f'
AND organization_person_id = 'a90ca3e4-9bc2-4043-a5ec-f7c6a291558f'
AND legal_name LIKE concat('%','Sandra','%')
AND cipher_schema."Transaction".transaction_date >= '2020-05-27'
AND cipher_schema."Transaction".transaction_date < '2020-05-28'
GROUP BY
legal_name;
1 curtida