CREATE PROCEDURE sp_get_user_course_test
	@userId int,
	@groupId int
AS

	SELECT 
		cs.COURSE_SCHEDULE_ID,
		cs.COURSE_SCHEDULE_ID,
		co.TITLE,
		co.SHORT_TITLE,
		cs.START_DATE,
		cs.END_DATE,
		cr.COMPLETE_STATUS,
		cr.STATUS as ROSTER_STATUS,
		cs.STATUS as SCHEDULE_STATUS,
		co.STATUS as OFFERING_STATUS,
		co.COURSE_FAMILY_ID,
		co.COURSE_OFFERING_ID,
		co.DESCRIPTION,
		co.SHORT_DESCRIPTION,
		co.ENROLL_LIMIT
	FROM
		COURSE_ROSTER cr,
		COURSE_SCHEDULE cs,
                COURSE_OFFERING co
       	WHERE
	     cr.CUSTOMER_ID = @userId and
             cr.COOURSE_SCHEDULE_ID = cs.COOURSE_SCHEDULE_ID and
             cs.GROUP_ID = @groupId and
             cs.COURSE_OFFERING_ID = co.COURSE_OFFERING_ID
        ORDER BY
		co.TITLE