I was happy to read Iggy Fernandez announce that the second installment of the NoCOUG SQL Challenge is coming soon. I was very impressed with the quality of answers that were submitted for the first challenge last year, especially the winners answers which made my answer appear extremly elementary. 🙂
The Second International NoCOUG SQL Challenge has been published in the February 2011 issue of the NoCOUG Journal. The Journal can be downloaded from http://bit.ly/gVNZsW. SQL commands for creating the required data are available at http://bit.ly/g58WVn.
Hi Iggy – Thanks for letting me know. I will take a look and do my best to put a solution together.