So today I took my time to read SQLite docs about window functions and changed 3 queries (written copy&past-ing without really understand) which took almost 3 seconds to run, to one query which runs in 0.1 seconds.. nice :)
Hypolite Petovan likes this.