A more complex example to show how to make advanced reports.
column "modified" does not exist LINE 16: (CASE status WHEN 'closed' THEN modified ELSE (-1)*p... ^