Hi Benedikt, I wrote up this for you as an example.
SELECT DISTINCT p.NAME, p.SURNAME, SUM(c.LENGTH) OVER(PARTITION BY p.NAME) as sum_len FROM PERSON p JOIN TOPO t ON p.ID = t.PERSON_ID JOIN CENTRELINE c ON c.ID = t.CENTRELINE_ID; I hope this get’s you started. Eoghan > On 20 Feb 2025, at 13:54, Benedikt Hallinger via Therion <[email protected]> > wrote: > > Hi, > before I dig into SQL myself, does by chance somebody already made a > script or SQL to generate a list showing: "who has drawn how much length > of the surveys". > > Something along: > Person A: 250m > Person B: 199m > Person C: 80m > ... > > > Thank you :) > _______________________________________________ > Therion mailing list > [email protected] > https://mailman.speleo.sk/listinfo/therion _______________________________________________ Therion mailing list [email protected] https://mailman.speleo.sk/listinfo/therion
