postgresql7.3 select et.task_id, et.task_name, et.weight from evaluation_tasksi et where content_revision__is_live(et.task_id) = true and et.grade_id = :grade_id order by task_name select cu.first_names||', '||cu.last_name as student_name, cu.user_id $sql_query from cc_users cu $orderby select cu.first_names||', '||cu.last_name as student_name, cu.user_id $sql_query from cc_users cu, registered_users ru, dotlrn_member_rels_approved app where app.community_id = :community_id and app.user_id = ru.user_id and app.user_id = cu.person_id and app.role = 'student' $orderby , [lc_numeric trunc(evaluation__task_grade(cu.user_id,$task_id),2)] as task_$task_id , [lc_numeric trunc(evaluation__grade_total_grade(cu.user_id,:grade_id),2)] as total_grade