Fractal Interview Question

One Case Clause question in SQL.