Hi guys, been struggling with this for a while, wondering if anyone can help me.
I have set up a music pop charts database with the following relationship
I am producing charts for each week and have managed to write a query to get various positions for each song, eg entry position, highest...