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