URL: http://localhost:8080/virtualcollege/db_connections/get_class_list/

<dtml-comment>
 This function returns: code, course, credits, contact_hours, fee, notes, section, contact_days,
 start_at, end_at, room, class_limit, instructor_lastname, instructor_firstname

</dtml-comment>
SELECT DISTINCT catalog.course_code AS CODE, catalog.course_name AS COURSE, 
	catalog.credits AS CREDITS, catalog.contact_hours AS CONTACT_HOURS, 
	catalog.course_fee AS FEE, catalog.notes AS NOTES,
	class_list.section AS SECTION, class_list.contact_days AS CONTACT_DAYS, 
	CAST(class_list.contact_hour_start AS TIME) AS START_AT, CAST(class_list.contact_hour_end AS TIME) AS END_AT,
	class_list.room_number AS ROOM, class_list.sit_limit AS CLASS_LIMIT, 
	faculty.lastname AS INSTRUCTOR_LASTNAME, faculty.firstname AS INSTRUCTOR_FIRSTNAME
FROM catalog, class_list, faculty
WHERE faculty.faculty_id = class_list.instructor_id AND catalog.course_id = class_list.course_id
ORDER BY catalog.course_name
LIMIT 10;