Simple sql Task

I am looking for an experienced SQL developer to complete a simple, straightforward task. Just check the attached file and send me a sample by doing any of it. Then I'll award you the project and if you can successfully complete this then there will be a lot more projects in future.