H.S.Bhathiya(110059X) edited section_Proposed_Solution_We_propose__.tex  about 8 years ago

Commit id: 95d0c99a57ac0c2fce443b763615b80577b354e8

deletions | additions      

       

\begin{verbatim}  WITH  t1 as (SELECT \/\* \+ /*+  no_merge \*\/ */  INSTRUCTOR.ID as Instructor_ID, COURSE.COURSE_ID, COURSE.COURSE_ID as T1_ID FROM INSTRUCTOR ,TEACHES,COURSE   WHERE TEACHES.COURSE_ID=COURSE.COURSE_ID),  t2 as (SELECT \/\* \+ /*+  no_merge \*\/ */  STUDENT.ID as Student_ID, student.name as Student_Name, COURSE.COURSE_ID, COURSE.COURSE_ID as T2_ID, COURSE.TITLE as TITLE FROM COURSE, TAKES, STUDENT   WHERE TAKES.COURSE_ID = COURSE.COURSE_ID AND STUDENT.ID = TAKES.ID)  SELECT t2.Student_ID, t2.Student_Name, t1.Instructor_ID, t2.TITLE