Yesterday I was looking at the 25 Most Played smart playlist in iTunes and saw that these songs are all approaching 50 times.
So I was wondering: how many times has each track been played on average?
As regular readers are aware I've put my iTunes database in MySQL
Given that, it's fairly straightforward to extract this information.
mysql> SELECT sum(playCount)/count(trackID) as average FROM phptunest_tunes;
| average |
| 2.18 |
1 row in set (0.07 sec)
(This post was brought to you by the useless statistics department.)