Question

Write SQL queries to answer the following questions:

a. List the numbers of all sections of course ISM 4212 that are offered during the semester “II-2015.”

b. List the course IDs and names of all courses that ends with the letters “Analysis”

c. List the IDs of all faculty members who are qualified to teach both ISM 4212 and ISM 3113. Make sure to only list one ID for each faculty.

d. Modify the query above in part c so that both qualifications must have been earned after the year 2005.

Answer 1

Please find the solution below. Let me know if you have any doubt.

a) select SectionNo from SECTION where CourseID='ISM 4212' and Semester='II-2015';

b) select CourseID, CourseName from COURSE 
where CourseName like '%Analysis';

c) select unique(FacultyID) from QUALIFIED 
where CourseID in ('ISM 4212','ISM 3113');

d) select unique(FacultyID) from QUALIFIED 
where CourseID in ('ISM 4212','ISM 3113') and DateQualified >= '1/1/2005'