華南農(nóng)業(yè)大學數(shù)據(jù)庫系統(tǒng)概念實驗報告三-文庫吧在線文庫
【正文】 ximum and minimum enrollment across all sections, considering only sections that had some enrollment, don39。 AND credits = 3(2) For the student with ID 12345 (or any other value), show all course_id and title of all courses registered for by the student. SELECT course_id,titleFROM takes NATURAL JOIN courseWHERE id = 123454. As above, but show the total number of credits for such courses (taken by that student). Don39。Comp. Sci.39。)(5) Display the IDs of all instructors who have never taught a course (Notesad1) Oracle uses the keyword minus in place of except。(10) Find instructors who have taught all the above courses 1). Using the not exists ... except ... structure 2). Using matching of counts which we covered in class (don39。as final_gradefrom F natural join studentgroup by namehaving count(grade)=2。2. The university rules
黨政相關相關推薦
鄂ICP備17016276號-1