News for hackers. Stuff that matters.

A comment on Show HN: Visualize your Apple Music stats. Parent comment

Re:Show HN: Visualize your Apple Music stats by unzadunza on Thursday July 13, 2023 @07:41PM (#36717583) 

  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.
[ Parent | on HN ]
Re:Show HN: Visualize your Apple Music stats by jakear on Thursday July 13, 2023 @07:53PM (#36717680)
Yeah last played is a good one. I actually have a smart list of all the top played songs that were last played over a year or two a go, which I look through to find some "fell through the cracks" things I enjoyed at one point.

What I most want is a way to count the plays that happened between a set of dates...

[ Parent | on HN ]