Hi Thomas,

Why did you post the puzzle as a contest ? It was not listed in the official contests list on SSC. I don't like situations like this, when it is possible that some SSC members abuse the enthusiasm of others. This may destroy the community spirit of the site.

Why don't you post the puzzle URL here ? I suppose that many of us are interested in SQL puzzles, so we can test our knowledge, too.

According to this part of your post:

"my Q1 should return 3000...How to do it.? Will using ALL will help?"

I can conclude that you are a newbie to SQL. Why don't you try yourself with easier puzzles ?

Regards,

Goce.