mySQL professionals - I need a Query

[DevPunk]

This job is for mySQL professionals. I need one query (maybe 2? you will tell me which is better).
Specifications see here. For questions, just start a conversation. I pay by PP.

 

[Vekseid]

This appears trivial. Posted a solution though I may have a typo or swapped something around on accident. Test the independent queries first.

 

[DevPunk]

This appears trivial.

Unfortunately not for me... But I was hoping that someone would see it that way and be able to help....