I'm making a list with certain songs. Each song has its own unique ID. OK let's say I have this table called list
. A new:
The ID is self-explanatory. It's used to ID rows. song_one
through song_ten
is filled with a song's unique ID.
Every time a user makes a new list
, they add songs and each row gets filled. Now, how would I get the average rank of the songs in the tables list
using the song's ID that is filled between song_one
through song_ten
?