Complicated query

[Puiu]

I have the following tables in my database:

Media(IdMedia, Description)
Images(IdImage, IdMedia, Size)
Requests(IdRequest, IdMedia, DownloadDate, Aproved)

I need to create a query that will calculate the total downloads of each image and show the user the percentage of those downloads in the total number of downloads in the current month
Example:
Let

 

[Afraits]

Not that Im aware of. I had to use a similar method for a similar problem a few months back.