Course Course number Credit hours Department Couse_name Into to information syst

Question

Course Course number Credit hours Department Couse_name Into to information system Student IS1310 Major Name Student Number Class smith brown IS IS MATH iS 17 Data structures Discrete mathematics Database IS3320 Math2410 IS3380 IS Grade report Section identifier Course Number Semester Year instructor Student Number 17 17 Section identifier 85 92 102 112 119 135 MATH2410 IS1310 IS3320 MATH2410 IS1310 IS3380 Fall Fall Grade 15 15 16 16 16 16 King Anderson 119 85 92 102 135 Fall Fall Fall Chang Anderson Stone SECTION 28) Using the above relation, write a SQL. Statement to display Course number, Semester, and Instructor all courses offered in year 16 sorted by Course number with ascending order 29) Using a subquery, write a SQL statement to display Course number, Instructor, and grade for student "Brown"

Explanation / Answer

28) SELECT C.COURSE_NUMBER,S.SEMESTER,S.INSTRUCTOR FROM COURSE C,SECTION S WHERE C.COURSENUMBER=S.COURSENUMBER AND S.YEAR=16 ORDER BY C.COURSE_NUMBER ASC;

HERE WE WILL JOIN THE TABLES BASED ON THE COMMON FIELD COURSENUMBER AND WILL CHECK FOR EQUALITY AND THE YEAR 16.

29) SELECT S.COURSENUMBER,S.INSTRUCTOR,G.GRADE FROM SECTION S,GRADE G WHERE S.STUDENT NUMBER=(SELECT S1.STUDENT NUMBER FROM STUDENT S1 WHERE S1.NAME LIKE 'BROWN')

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---