[Therion] Generating list of drawers

[Eoghan]

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 <therion at speleo.sk> 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
> Therion at speleo.sk
> https://mailman.speleo.sk/listinfo/therion