Students Course Query

-----------------------------------------------------------------------------------------STUDENT-COURSE DETAILS:= FOR ANY COURSE, DISPLAY THE COURSE DETAILS AND A LIST OF STUDENTS REGISTERED FOR THE COURSE -----------------------------------------------------------------------------------------SELECT BOOKINGS_COURSES.COURSE__CODE,COURSE_NAME,COURSE_LEVEL,COST_OF_COURSE,COURSE_DURAT ION, COURSES.START__DATE,BOOKINGS.STUDENT_NO,STUDENTS.STUDENT_NAME FROM STUDENTS,BOOKINGS,BOOKINGS_COURSES,COURSES WHERE STUDENTS.STUDENT_NO=BOOKINGS.STUDENT_NO AND BOOKINGS.BOOKING_REF_NO=BOOKINGS_COURSES.BOOKING_REF_NO AND BOOKINGS_COURSES.COURSE__CODE =COURSES.COURSE__CODE AND BOOKINGS_COURSES.COURSE__CODE='CR01';