I am tring to make a query but I am a beginner in SQL commands. Example is following:

There is the table which is my database and Query will look like that. I have added everything to picture.

I am using MS SQL 2005
(Sorry about my english)

Thanks for every kind of help