select artist, sum(plays) from plays where last_played > '2023-01.01' group by artist order by sum(plays) desc limit 20; ┌───────────────────────────────┬────

select artist, sum(plays) from plays where last_played > '2023-01.01' group by artist order by sum(plays) desc limit 20; ┌───────────────────────────────┬────────────┐ │ artist │ sum(plays) │ │ varchar │ int128 │ ├───────────────────────────────┼────────────┤ │ Mush │ 97 │ │ Waylon Jennings │ 83 │ │ The Klittens │ 82 │ │ Widowspeak │ 80 │ │ Glyders │ 71 │ │ Big Thief │ 69 │ │ Duke Ellington │ 66 │ │ Wet Leg │ 59 │ │ Bachelor, Jay Som & Palehound │ 54 │ │ Spencer Cullum │ 51 │ │ Thee Oh Sees │ 51 │ │ abracadabra │ 49 │ │ The Beatles │ 48 │ │ PACKS │ 44 │ │ Pozi │ 43 │ │ Miles Davis │ 38 │ │ Sorry │ 37 │ │ Thievery Corporation │ 34 │ │ Daniel Rossen │ 32 │ │ Melin Melyn │ 31 │ ├───────────────────────────────┴────────────┤ │ 20 rows 2 columns │ └────────────────────────────────────────────┘ It's interesting to add 'last played' to the smart playlist.