SQL Practice Window Functions and CTES: SQL 30 Day Challenge Day 28

[@1996warman]

I have no idea how Perplexity recommended me your video considering it has less views, but you have done a great work. Now I am curious on how did Perplexity thought of recommending your video

[@obadelej]

I have an SQLite database with with a table called cc_results for the results of a cross country race. The tables have the following fields, team_code, first_name, last_name, gender, position, mark. I will like to write a query that will group the teams, sum the top3 positions for each team and rank the teams in ascending order. How can this be done?