select ID,
       START_DATE,
       END_DATE,
       TASK_NAME,
       case STATUS
           when 'Open'    then 'apex-cal-green'
           when 'Pending' then 'apex-cal-yellow'
           when 'Closed'  then 'apex-cal-red'
           when 'On-Hold' then 'apex-cal-black'
       end as css_class,
       ASSIGNED_TO as supplemental_info
  from PROJECTS