Query the names of the students who enrolled all of the courses

Query the names of the students who enrolled all of the courses. Active = 1. GRADE FROM GRADES AS G. Display all courses for which Professor Berndt has been qualified. SectionNo, Semester FROM Student, Registration, Section WHERE Section. Class_ID, Class. Write a query that returns the department ID and department name for all departments for which no courses have been assigned. Write SQL retrieval commands for each of the following queries: a. mysql. Fill in the blanks. SAMPLE DATA Nov 21, 2019 · How to write a query to find all students who took many courses together. But I can't establish a relation between table Student_1 and Course. For each course C Sep 20, 2013 · ON a. id AS. For example, the query "Student Enrolled" returns the ID and name of all students who are not enrolled in any courses. " Solution: Below is the required query and the snapshot Query SELECT s. ID) inner join `Course` as c on (c. courseId join studentCourse S ON C. Course_number Write an SQL query to list the names of students, along with the titles of the courses they are enrolled in the Computer Science department in the Fall 2 0 1 7 semester, and include the room numbers where these courses take place. courseid = <your course id>. sid and A1. Department = 'Automotive Engineering'. I want to display all the enrolled courses in a unorderd list to the user. sid was removed. There are 2 CID)); Division Find student S such that There is no course C Which is not enrolled by S Query : Retrieve the name of the students who are enrolled in ALL the courses 101, John CPSC 304 Enrolled- 101,304 (found a tuple). Retrieve the names of all students that got an A in course CS1310. Stud_name,a. g. For those enrollments for which fee have been waived, provide the names of students who have got ‘O’ grade. ) Write a SQL query that retrieves the names and email addresses of all students who are enrolled in at least one course in the "Computer Science" department and have a graduation year of 2022 or later. c) → Find the names of students who Apr 4, 2018 · Problem Table " I think for this all three tables will be used. CourseID IN ('Course1', 'Course2', 'Course3') 'Assuming students' name and instructors' name are unique. Sep 11, 2019 · You can approach this problem using conditional aggregation based filtering. CourseID=q; WHERE q = 3467. snum = student. b) Find the names of students who have enrolled in course Calculus. (Hint: Please use “%” in relational algebra to describe this query You might want to refer to Week 1 Exercise Question 7 before finish this query) Ans: Π SNAME,CNO ( S |×| SC ) % Π CNO(C) Jul 14, 2019 · Or, you could use intersect to find students that occur in both sets: select studid from registration where courseid = 100 intersect select studid from registration where courseid = 101; Or just for fun, collect all coursids for each student into a collection and then check whether (100,101) is a subset of that: 3. IF( (SELECT G. Retrieve all the courses taken by student whose number is 8 in the fall of 2008. name = 'John' ) When you want to query for information about a student’s enrolled courses or a course’s enrolled students, you can use JOIN operations to link these tables together. Display the class roster, including student name, for all students enrolled in. . Display the numbers and names of all courses for which Professor Berndt has been qualified. select email. select StuName,grade from StudentMaster SM Jul 15, 2017 · The only way I've been able to come up with the answer is along the lines of. We can also use a left join to join the Students table with the Departments table on the condition of Students. student_id = 1 or if search for all students then disable e. Select all Courses, and for those in which a certain Student is enrolled, also select the Enrollment data 1 SQL query to select students who have taken all subjects from subjects table Dec 15, 2015 · ENROLLMENT (snum: int, cname:varchar(100)) where snum is the student id and cname is the course name and I want to find the name(s) of the class(s) with the most students enrolled. I am new with sql queries so dont know much. Create a query to show the names of the students who are enrolled in 3 or more sections. courseName FROM course c Where (select count (*) FROM Enrollment e where e. Write an SQL query to find the students and their enrolled courses. Write SQL queries to answer the following questions: a. Student_Name. The idea of the related name is to be able to do a 'backwards' lookup on the model the relationship is defined on from the model the replationship is not defined on. Retrieve student's enrolled course info. GROUP BY enroll. Jul 22, 2016 · Below query will show all student that did not attend 1 or more classes, including the class name. 2_write a query that lists the total number of students that were enrolled in classes during each Feb 28, 2018 · Students -- rows where student [snum] is enrolled in offering [onum] Enrolled Every query result holds the rows that make a true proposition from some predicate. last_name. AND st. You should have 7 rows. (This query returns a student's name if the student has received more than one mark in a subject, so long as one of those marks is the highest for the subject. Question: 1)write a query to list the course names and the number of students in those courses for all courses where there are no assigned faculty. book) = 2. CourseId. there are three tables students,courses,registration Aug 11, 2019 · Solution 1: Subquery. on c1. Student_ID int, Course varchar(15), Score int, Semester varchar(15), Discipline varchar(10), Campus varchar(15), Degree varchar(10), Year int Sep 9, 2021 · 1. Include the course name and instructor name for each enrollment in the output. I filter it wih module name or module id. There are 3 > 6 was changed to < 6 because you want to have courses with a small number of students. FROM Student st. Display the numbers and names of all courses for which Professor Berndt has. and there is third table joining the Students and Courses table. Nov 28, 2019 · Consider the following relations Student(Sid,Sname) and Apply(Sid,Cname,major). I Apr 3, 2024 · Consider the set of relations shown below and the SQL query that follows. Using this database schema example, the query could be written two different ways: Option #1. NetId VARCHAR(10) FirstName VARCHAR(255) LastName VARCHAR(255) Department VARCHAR(100) Enrollments. course_id, Course. student_id = s. StudentID May 13, 2012 · In other words, select a student X's name if there is no subject in which someone's mark for that subject is not matched or exceeded by some mark belonging to X for the same subject. SELECT C . FROM t_course. e 1, 2, 5 then use e. snum or student. Feb 10, 2023 · 4. fid and faculty. Feb 25, 2019 · ORDER BY totalEnrollment DESC; For your second query, you need to use an alias when you join the same table twice, and also you didn't do anything to check for "offered by a different department". Feb 6, 2021 · inner join enrolled on enrolled. student < c2. cname)>4; Here are the class table and the enroll table. The query below answers the university's question. student_name. Mar 1, 2013 · 0. Apr 11, 2015 · For each department that has one or more majors with a GPA under 1. Book IN('Maths','Eng') GROUP BY t. Checks whether to use the legacy course access list. student, c1. List the names of students and the names Retrieve the names of students enrolled in the 'Automata' class in the term of Fall 1996. SELECT MAX(t_course. (select distinct sid from enrol where code in. WHERE t. Aug 4, 2010 · The first query below assumes there may be duplicate records in student_has_teacher, and will avoid causing duplicate results even if that is the case: select s. Students: (Roll_number, Name, Date_of_birth) Courses: (Course number, Course_name, Instructor) Grades: (Roll_number, Course_number, Grade) select distinct Name from Students, Courses, Grades where Students. Retrieve the SID values of students who have enrolled in CSc226 as well as CSc227 c. student_id from student_has_teacher sht inner join teacher on sht. id, and then filter out the students whose Departments. Dept_id = b. Find the total number of students enrolled in each department's courses. Write a query to list students’ First Name, Last Name, and Number of Courses they are taking in their major department. sid = A2. The output should be sorted first in increasing order of the number of courses, then by student last name. Question: 8. fname='Ivana Teach' To find students whose major is English or enrolled in a course taught by Ivana Teach, you should use a WHERE clause instead, as follows: Nov 16, 2012 · Write a query that displays the student firstname, lastname, course number, and course name for all students taking classes – use an INNER Join. LastName, Class. SectionNo= Registration. my query right now looks like F. database. SID = c. student_id, a. Jun 8, 2016 · 2. My Query which passes the testcase but its redundant , I Want to save the subquery variable. name inner join faculty on faculty. you can choose either one. LEFT OUTER JOIN Course c ON c. SectionNo AND Student. course_id = c. Gets all courses accessible by the user’s groups. [5] Insert the following new tuple in Students: John with sid as22222. (select distinct code from enrol where sid in. There are three tables. i have a table named registration. Label the output columns Student First, Student Last, Course Number, and Course Name. Queries that I tried: SQL: SELECT SName FROM student WHERE semester='third' SELECT CNAME FROM student s, studies st, course c WHERE s. name as StudentName, c. d. Retrieve the names of students who have not enrolled in any class. StudentID, StudentName, Section. LAM. The predicate of a relation expression is combined from the predicates of its argument expressions depending on its predicate nonterminal. Jul 18, 2018 · SELECT c. The query below answers the university's question. Retrieve the Sid values of students who have enrolled in CSc226 and CSc227. The join of enroll. Any help would be appreciated. LastName, (A)FROM Student STINNER JOIN Enrollment E ON ST Sep 9, 2022 · 9. dept_name, Prereq. Arrange the list by number of sections from Apr 3, 2018 · Write a query to display the names of all students who have secured more than 50 in all subjects that they have appeared in? 1 SQL query to get instructors and students has invalid identifier 3 Database Manipulation and Views Consider the relations Courses, Professors, Students, Enrolled as described in ques- tion 2. [5] Update the name of the student with sid as22222, to Doe. Nov 4, 2020 · The tables including fields required to write the query for this question are: Student. been qualified (10%). Prog_Name FROM Module a INNER JOIN Programme b ON a. May 7, 2021 · A couple of things. Jan 24, 2021 · Mysql getting all subject with student name even if id is not there 2 Select all Courses, and for those in which a certain Student is enrolled, also select the Enrollment data Jan 21, 2020 · If there is more than one student with the same grade (1-7) assigned to them, order those particular students by their marks in ascending order. FirstName, Student. is the question in my lab. Retrieve the Sid values of students who have enrolled in CSc226 or CSc227. SELECTC. Class_ID Feb 25, 2019 · Hi I have a schema that looks like this. Gets all courses for the user via the user meta ‘course_XXX_access_from’. D. If you are looking to show the list of users per course and list the non-enrolled users you can do the following: FROM mdl_user u. If you are not familliar with joins. I have found a few solutions from the Internet, and most of them suggest joining these tables: context, role_assignments, course, user, role Nov 11, 2019 · Consider the following schema: Student (snum, sname, major,level) Class (cname, meets-at,room, fid) Faculty (fid, fname, depname) Enrolled (snum, cname) write an SQL query to find the names of all the classes that don't meet in room R128 with the smallest number of students (compared to all other classes). NetId VARCHAR(10) For example, the query "Student Enrolled" returns the ID and name of all students who are not enrolled in any courses. [5] Remove all professors from Professors, who are not teaching any course. Tables schema: Student: ID int, Fname nvarchar(50), Lname nvarchar(50) Course: Course_ID int , Name nvarchar(100), Created_date datetime; Enrollment: Student_ID int, Course_id int; For example: I want to see students who have taken more than three courses together. enrolid. Which of the following SQL queries finds sids of all the students who apply for CS but not for ME? Option 1: Select A. Dec 23, 2020 · In your query, you are listing all users enrolled (active/inactive) in all your courses. Discuss the logic behind your query and how it ensures accurate data retrieval while maintaining data. student, c2. If you are using id s and not names in the tables (a good idea), then you will Question: Write an SQL query that returns the studentid and name of students that enrolled in all of the finance courses. I have included usn in the results so as to uniquely identify students as it can not be safely assumed that no two students will have the same value for sname. name AS StudentName, students. class and. We can directly use a subquery to find all students who are not in the Departments table. Apr 13, 2015 · We join student to enroll tables to get a list of all courses the students are enrolled in, we filter it to only courses that are in the Civil Engineering department, we then group them by student, and count the number of distinct courses the student is enrolled in (since in real life, a student may end up enrolling in the same course multiple Write an SQL query that retrieves the names (first and last) and ages of all students who are enrolled in the "Computer Science" department. Student_ID = Student. id= S. The classes with 5 or more students are Database Systems and Operating System Design. SID AND st. Gets the list of course IDs accessible by the user. The Query to get the desire result will be--- …. To find active students not on a course then something like this:-. b. name as CourseName from `Student` as s inner join `Student_Course` as sc on (sc. major = 'English' inner join class on enrolled. e) Find the sids of students who have enrolled in all courses (both Courses1 and Courses2). But giving only 2 students instead o Jul 6, 2020 · If you see, the student 1 has enrolled on 2020-01-01 and then enrolled out on 2020-01-02. StudentId = st. LEFT JOIN curses c. SELECT. LEFT OUTER JOIN Student_Course sc ON sc. id in ( select sht. sql. ID = sc. Apr 26, 2018 · 1. . You can use the HAVING clause to filter only those who have both Maths and ENG : SELECT t. department_id = Departments. Schemas of the tables are below. There are three tables here, Students. 96% (55) View full document. class = c2. – Stack Acc. Stud_id = c. GROUP BY s. class. id = ue. student_id = b. With count () you can select the number of Students. Jul 14, 2015 · A list of all users that are enrolled in to a specific course in the last 90 days that is not suspended or deleted. courseID and ) but i am not sure after this how should i select the students with moren than 100. the output should be sorted first by the number of students in descending order then by course name in ascending order. FROM STUDENTS S. Student_ID AND Student_Class. SELECT st. SID = st. Solution 2: Left Join. Like some other relational operators (e. FirstName, ST. 0, print the name of the department and the average GPA of its majors. The query must display the StudentID, FirstName, LastName, CourseID, and CourseName of each student and his courses. major = 'CS' and A2. Student Table Student_id course_id first_name 201353 10 Loren 201216 20 Lizzie 201333 30 Michelle 201463 40 Wiley 201112 50 Alfonzo 301589 10 Chris 201493 60 Dorothy 201319 80 Mathew Course Table Course_id course_name 10 BIT 20 BBA 30 Bsc Csit 40 Data Analytics 50 Msc IT 60 MBA Question: The table diagram below describes a university's database. Feb 20, 2015 · 1. This join was incomplete. Courses has also course. NAME, FC. Apr 4, 2018 · In the case of selecting all of the courses for a given student ID you could try the following, which will return one row for each Course a Student is associated with. If search for specific student then enable e. Feb 17, 2021 · I am trying to write an SQL query that returns for each department, the department name and average number of students enrolled in courses offered by that departmen. from ClassStudents c1 join. SELECT Student_Name. from student where sid in. Dec 18, 2017 · there'll be joins, group by and having count here. SELECT Course. b) → Find the names of students who have taken all courses instructed by Goliath (instructor name). Been stuck on these for a while. FROM Student Write a query that lists the total # of students that were enrolled in the beginning of classes during each school year (from January 25th 2014 up to August 25th 2017). Find the names of all courses studied by 'Ram'. id. Students are required to take 4 courses, and at least two of these courses must be from the department of their major. ) Expert-verified. Try focusing on one step at a time. student; If two students attended multiple classes together, this will return one row per class. Registration : stu_id, course_id. Find the names of the top 4 instructors who have taught the most number of distinct courses. Module_Name,b. 10. You need to join first all the tables using LEFT JOIN since you want to show all students. CourseId = sc. 84. StudentId. (Hint: fist of courses with at least one enrollment (previous query) minus list of all courses, you can get list of courses with no enrollment. Retrieve the total number of students in the database. Nov 21, 2020 · WHERE room='R128'. (select sid from student where sname = 'Alice') --In case you have more than one Alice students it still get all classmate of all Alice. HAVING COUNT(enroll. level = 1) counts all records where level is equal to 1, if the result is greater than 0, it means that the Dec 12, 2018 · LEFT JOIN rosters r ON r. By using Inner Join on the tables "table_courses" & "table_student_course" we selects all rows from both tables as long as there is a match between the columns in both tables making sure the ids are the same. ClassStudents c2. FROM Student s CROSS JOIN Course c. 5. 6. 1. Question: Write a SQL query that retrieves the names and email addresses of all students who are enrolled in at least one course in the "Computer Science" department and have a graduation year of 2022 or later. WHERE S. StudentId, StudentAlias, StudentForename, StudentSurname. It counts all the distinct class_id values in roster for each student ( num_classes) and returns only students with 2 or more ( HAVING num_classes >= 2 ). (1) Your related_name for courses on your student model is a little confusing. c. SELECT ST. e. The classes in room R128 are Patent Law, Data Structures, Archaeology of the Incas, Dairy Herd Management, and Introduction to Math. STUDENT_ID, s. Write a query to help Eve. (7) Query the names of the students who enrolled all of the courses. SELECT Student. * Student (ssn, name) Prof (ssn, name) Course (number, instructor-ssn, title, credits, room#) Enroll (student-ssn, course#) Room (number, capacity) Write a relational algebra query that finds the names of all students who are enrolled in a class taught by "Jones," AND are enrolled in a class called "Physics. 4 Antijoin is the converse: E 1 E 2 retuns all tuples in the result of expression E 1 such that there are no tuples in the result of E 2 with matching values for the shared attributes. facultyID AS '# OF FACULTY', COUNT(S. Try this query. 3. Print the ids, names, and GPAs of the students who are currently taking all of the Civil Engineering courses. I would like to find the name of Students registered in only one course. @DhruvJoshi I am trying to do this in this way: Select c. Basically, I want to write a query whose output is students like 1, who have atleast enrolled once and final status is not enrolled. last_name,t. JOIN mdl_enrol e ON e. ) course no (1, 3). The first column should have the header “Students”. One Student can take one or many courses. –11. I was trying to make these 3 queries. Display the course ID and course name for all courses with an ISM prefix (10%). LEFT JOIN mdl_user_enrolments ue ON ue. Do not forget that when you use Set Operations (Union, Intersection, Difference), the relations must be compatible (same number of attributes and same type) 3. Write SQL retrieval commands for each of the following queries: Display the course ID and course name for all courses With an ISM prefix. Students has id, name columns. Retrieve the SID values of students who have enrolled in CSc226 or CSc227 d. ON b. Apr 29, 2014 · 2. Roll_number = Grades. dept_name. sid from Apply A1,Apply A2 where A1. Retrieve the maximum number of credits for the database courses. AND E. count. Class_name FROM Class, Student WHERE NOT EXISTS ( SELECT * FROM Student_Class WHERE Student_Class. courseId. Student 2 and 3 have never enrolled. name from student s where s. Roll_number and Courses. Using the above, write a query to list the course names and the # of students in those courses for all courses where there are no assigned faculty. course_ID. Provide a second “Year” column showing the enrollment year. NAME) AS Course_name, COUNT(t_enrolment. major <> 'ME' Option 2: Query: SELECT f, c,c FROM Faculty f JOIN Qualified q ON f = q JOIN Course c ON c. Unpopular courses. If the condition is met ( student_id=1) then the query will return what is expected. c1. @ APCThis code is working. HAVING COUNT(distinct t. student_id IN (1, 2, 5) -- MySQL. FROM student_books t. Sep 17, 2013 · 1. SELECT s. Course_number = Grades. Course. Firstly, get all the students who are either enrolled IN(. d) Find the names of students who have enrolled in Calculus or Algebra. "students" table: Dec 23, 2021 · professor (prof_id, prof_name, dept_id) course (course_code, name) semester_course (course_code, quarter, year, prof_id) enrolled (student_id, course_code, quarter, year, enrolled_at) the question is Find names of all departments whose professors collectively teach less than 3 courses. Dec 14, 2017 at 23:53. Your output should contain the student ID, first and last name of the students and the number of sections enrolled. Student_ID, Student. Display the class roster, including student name, for all students enrolled in section 2714 of ISM 4212: Query: SELECT s, s, sc, r, Semester FROM Section sc JOIN Registration r ON sc= r JOIN Student s ON s= r WHERE r= AND sc=‘I-2008 Using the above, write a query to list the course names and the # of students in those courses for all courses where there are no assigned faculty. Mar 4, 2014 · I was looking for the proper SQL queries for retrieving all students enrolled in a certain course, or all courses a certain student has enrolled in, on Moodle. – RoMEoMusTDiE. Sep 2, 2020 · I have a learndash site in WordPress with many courses. Results would be something like: course id: 20 user id: 200, 533, 221, 22, 356 Consider the relational schema below: Students(sid: integer, sname: string, major: string) Courses(cid: string, cname: string) Enrollment(sid: integer, cid: string, grade: real) Write a tuple relational calculus expression that satisfies this query? Find the distinct names of all students who major in either "Math" or "Economics" who score less 5. CourseID, Registration. and I am using this query: SELECT DISTINCT students. Last Name_____ First Name_____ Student No_____ 10 c) Find the names of students who have enrolled at least one course. courseID) AS '#_Students' from course c left join facultyCourse FC on c. (02 Points) 2. Hint: Use COUNT, GROUP BY, and JOIN clauses to query the enrolled, course, and department tables. The condition was there, but you didn't include the student table in the query at all, and it made the query invalid. Instructor = Korth and Courses. The output should be ordered first by # of students descending and then by course name ascending. pdf. Id. CourseID = C. Jun 15, 2020 · CourseID NUMBER(10), Semester VARCHAR(100) And I want to find the names of courses that are enrolled by all “Automotive Engineering” students. mycourses => true in the arguments is not working. sid to student. Write a query that returns the professor id, professor last name and professor first name of any professors who are not advising any students. Sort on the professor last name. Display the course ID and course name for all courses with an ISM prefix. first_name,s. Dept_id INNER JOIN Student c ON b. Student_Id (this is the Id field from the Students Table) Semester. Here’s a simple example:-- Retrieve all courses for a specific student SELECT Courses. My code to get all the courses: Retrieve the names of students enrolled in the Automata class during the fall 2009 term. CID AND SName = 'Ram' None of these A B c Consider the following schema - STUDENTS(student_code, first_name, last_name, email, phone_no, date_of_birth, honours_subject, percentage_of_marks); Which of the following query would display names of all the students whose honours subject is English, or honours subject is Spanish and percentage of marks more than 80 ? A university wants to know the names of students who have enrolled in less than 4 sections in a single term,where all courses taken have fewer credits than the course with the most credits. id=fc. userid = u. FROM ENROLL E. CourseId IS NULL. Stud_id WHERE a. 4. List the names of the Courses enrolled by all (every) students. What tables contain data relevant to the university's question? Instructor SectionInstructor Section Course Enrollment Student. WHERE c. FROM Course. I tried the below statements but it shows nothing. Find Courses and Certifications from top universities like Yale, Michigan, Stanford, and leading companies like Google and IBM. Question: The university wants to know the names of students who have enrolled in less than 3 sections in a single term, where all courses taken have fewer credits than the course with the most credits. Join Coursera for free and transform your career with degrees, certificates, Specializations, & MOOCs in data science, computer science, business, and hundreds of other topics. Display the class roster, including student name, for all students enrolled in section 2714 of ISM 4212: Query: SELECT Student. this table has the following structure. , intersection, natural join), semijoin and antijoin are abbreviations - they can be defined in terms of other relational operators. Design an SQL Select statement to retrieve the names of all students enrolled in at least two courses. GROUP BY a. ( 6 pt for each) a) → Find the names of courses which is offered every semester. 2. CourseID. student_fk) AS Count_students. Students, Courses and Registration. WHERE NOT EXISTS (SELECT E. AND e. Find the total number of students who study 'DBMS'. Try to understand it. StudentID, c. name. course This function allow for filtering if to actually write the transient. teacher_id = t. For each department offering at least one course in which at least one student is enrolled, print the department name, the total enrollment of all courses offered by the department, the number of students enrolled in at least one of the courses offered by this department, and their average age. This statement SUM(c. Sep 5, 2014 · Select all courses from your course Table, join the enrolment table and group by your course id. HAVING num_classes >= 2. first_name, st. If you also want their names: SELECT s. You can do this with a self-join: select c1. Module_Name = 'Database' OR Module_ID = 013. 7. fid = class. I have a list which shows me all the courses, but not the current enrolled courses. Hence, not in the output. The university wants to know the names of students who have enrolled in at least 5 sections in a single term, where all courses taken have more credits than the course with the fewest credits. select s. prereq_id, c2. cname. student_id = 1 or if search for few students i. Consider a scenario where you need to extract information from a database containing tables for students and courses. id, course. There are 2 steps to solve this one. Note I've used a LEFT JOIN to catch all students, however since you want only those with 2. id, s. Retrieve the total number of courses that are worth three Nov 9, 2007 · Re: Databases: Query to show all students and his courses by Paul Davis - Thursday, 21 June 2012, 10:40 PM Hi guys, to get the parent category of a sub category in one query, add this to your select statement where you are displaying the columns you want to show. id where t. False CPSC 416 -- no tuple TRUE. student_id. A course is considered a finance course if the title of the course contains the string ’Finance’. Student 4 enrolled multiple times but never enrolled out. cname = class. courseID=c. List the names of the Local students who have enrolled for exactly 3 basic courses. The enrollment team is gathering analytics about student enrollment throughout the years. F …. id is NULL. [HINT: combining multiple select statements into one Aug 20, 2022 · Find the names of all students in 'third' semester. First of all I have this table structure and data as below: I would like to return all the other students for each common course they have for a specific student. id as StudentId, courses. May 7, 2017 · The usn and sname is then chosen from the list so generated WHERE the count of Grade values for a student that equal S equal the total count of courses for that student. Display the class roster, including student name, for all students enrolled in section 2714 of ISM 4212. Then, you can use HAVING clause to filter out the students having atleast two unique courses subscribed to (which would be 1 and 3 in this case): Assignment Informationa. xd td fr yc ui ou ya av yy qi