postgresql7.4
SELECT name, description, person__name(instructor_id) AS instructor,
instructor_id,
to_char(start_date, 'DD Month, YYYY') AS start_date,
to_char(end_date, 'DD Month, YYYY') AS end_date
FROM lrc_lab
WHERE lab_id = :lab_id
SELECT t.template_id, t.name AS template_name,
t.description AS template_desc,
to_char(m.start_date, 'DD Month, YYYY') AS release_date,
to_char(m.end_date, 'DD Month, YYYY') AS submission_date
FROM lrc_template t, lrc_lab_template_map m
WHERE m.lab_id = :lab_id
AND m.template_id = t.template_id
AND t.package_id = :package_id
ORDER BY m.end_date ASC
SELECT u.user_id AS student_id, u.first_names, u.last_name, u.email,
gs.group_name
FROM cc_users u, lrc_marker_group_map g, group_member_map m, groups gs
WHERE u.user_id = m.member_id
AND g.lab_id = :lab_id
AND g.marker_id = :user_id
AND g.group_id = m.group_id
AND gs.group_id = g.group_id