Johan Åhlén

Johan Åhlén's blog about life, universe and everything.

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!



No Comments