Fractal interview question

One Case Clause question in SQL.