Show personal stats #188

New Issue

philipp · 2024-01-23T10:34:52+01:00

philipp commented

2024-01-23 10:34:52 +01:00

Rowed km, grouped by year:

SELECT 
    u.name, 
    CAST(SUM(l.distance_in_km) AS INTEGER) AS rowed_km,
    strftime('%Y', l.arrival) AS year
FROM user as u
INNER JOIN 
    rower r ON u.id = r.rower_id
INNER JOIN 
    logbook l ON r.logbook_id = l.id
WHERE 
    l.distance_in_km IS NOT NULL AND 
    u.name like '<name>' 
GROUP BY year;

Rowed km, grouped by year: ```sql SELECT u.name, CAST(SUM(l.distance_in_km) AS INTEGER) AS rowed_km, strftime('%Y', l.arrival) AS year FROM user as u INNER JOIN rower r ON u.id = r.rower_id INNER JOIN logbook l ON r.logbook_id = l.id WHERE l.distance_in_km IS NOT NULL AND u.name like '<name>' GROUP BY year; ```

philipp added the

feature

label 2024-01-24 22:49:20 +01:00

philipp added the

Someday

label 2024-03-04 23:32:28 +01:00

Sign in to join this conversation.