Try your SQL optimizing skills and win great honor
As winner of the previous round, I’ve been given the honor to write the problem for Phil Factor Speed Phreak Challenge #6. This problem is from the real world (algorithmic trading) and the sample data is real.
The challenge is to reproduce highest buy and lowest sell prices from data captured from a stock exchange. There are four competition categories, all of which give you great honor and nice prizes:
Overall best performance (first prize)
Best SQL CLR solution
Best cursor-based solution
Best unconventional solution (be creative!)
Don't hesitate - give it a try!
Have fun and good luck!