Its nice to see SQL questions and answers. :-)

lets share relatively more difficult questions, so that we can make use of this thread to enhance our SQL knowledge.