What I’m trying to do
I have a folder called ‘lifts’ that that contains files that look like
---
date_of_workout: 2023-09-02
exercise: 'Bench'
weight: '275'
sets: '3'
reps: '3'
---
---
date_of_workout: 2023-09-03
exercise: 'OHP'
weight: '165'
sets: '6'
reps: '3'
---
I want a table that shows the heaviest lift for each exercise.
What I tried
TABLE exercise, weight
FROM "workouts"
SORT weight DESC
GROUP BY exercise
but leaves the weight column empty.