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

Commit id: 51b1daa3328c4d149332fe527205891692b1878c

deletions | additions      

       

\begin{document}  \begin{verbatim}  a SELECT STUDENT.ID as Student_ID, STUDENT.NAME as STUDENT_NAME, INSTRUCTOR.ID as Instructor_ID,COURSE.TITLE \\  FROM INSTRUCTOR ,TEACHES,COURSE, TAKES, STUDENT \\  WHERE TEACHES.COURSE_ID=COURSE.COURSE_ID AND TAKES.COURSE_ID  = LOAD `data' USING BinStorage AS (user);  b COURSE.COURSE_ID AND STUDENT.ID  = GROUP a BY user;  c = FOREACH b GENERATE COUNT(a) AS cnt;  d = ORDER c BY cnt; TAKES.ID\\  \end{verbatim}  \end{document}