[Therion] Generating list of drawers

[Benedikt Hallinger]

Well, that gives me "survey length per person" (isn't it?)
But I need "drawed length", to see who contributet how much to the maps 
drawings.

Am 2025-03-06 17:49, schrieb 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