2. Write an SQL query to answer the following question: Which instructors are qu

Question

2. Write an SQL query to answer the following question:

Which instructors are qualified to teach ISM 3113?

3. Write an SQL query to answer the following question: Is any

instructor qualified to teach ISM 3113 and not qualified to

teach ISM 4930?

4. Write SQL queries to answer the following questions:

a. How many students were enrolled in section 2714 during

semester I-2008?

b. How many students were enrolled in ISM 3113 during

semester I-2008?

5. Write an SQL query to answer the following question:

Which students were not enrolled in any courses during semester

I-2008?

Write an SQL query to answer the following question: Which instructors are qualified to teach ISM 3113? Write an SQL query to answer the following question: Is any instructor qualified to teach ISM 3113 and not qualified to teach ISM 4930? Write SQL queries to answer the following questions: How many students were enrolled in section 2714 during semester I-2008? How many students were enrolled in ISM 3113 during semester I-2008? Write an SQL query to answer the following question: Which students were not enrolled in any courses during semester I-2008?

Explanation / Answer

Dear,

2)

SELECT FacultyName
FROM FACULTY,QUALIFIED
WHERE QUALIFIED.FacultyID=FACULTY. FacultyID
AND QUALIFIED.CourseD='ISM 3113';

3)

SELECT FACULTY.FacultyNAME
FROM FACULTY, QUALIFIED
WHERE QUALIFIED.FacultyID=FACULTY. FacultyID
AND QUALIFIED.CourseID='ISM 3113'
AND NOT (QUALIFIED.CourseID='ISM 4930')

4)

a) SELECT COUNT (DISTINCT (StudentID))
        FROM REGISTRATION
        WHERE SectionNo = 2714
        AND SEMESTER = 'I-2008'

b) SELECT COUNT (DISTINCT (StudentID))
        FROM SECTION, REGISTRATION
        WHERE SECTION.SectionNO = REGISTRATION.SectionNO
        AND CourseID = 'ISM 3113'
        AND Semester = 'I-2008'

Hope this will help you!!

Related Questions

Navigate

• Browse (All)
• Browse 2
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.