1) How many students are enrolled in Section 2714 in the first semester of 2008?

Question

1) How many students are enrolled in Section 2714 in the first semester of 2008?

2) Which faculty members have qualified to teach a course since 1993? List the faculty ID, course, and date of qualification.

3) What are the courses included in the Section table? List each course only once.

4) List all students in alphabetical order by StudentName.

5) List the students who are enrolled in each course in September I, 2008. Group the students by the sections in which they are enrolled.

6) List the course available. Group them by course prefix, e.g. ISM.

Explanation / Answer

1) How many students are enrolled in Section 2714 in the first semester of 2008?
-> select count(StudentID) from Registration where SectionNo=2714 and Semester ='I-2008';

2) Which faculty members have qualified to teach a course since 1993? List the faculty ID, course, and date of qualification.
->select * from Qualifed where dateQualified ='9/1993';

3) What are the courses included in the Section table? List each course only once.
-> select distinct(courseID) from Section;

4) List all students in alphabetical order by StudentName.
-> select * from Student order by StudentName;

5) List the students who are enrolled in each course in September I, 2008. Group the students by the sections in which they are enrolled.
-> select count(StudentID) from Registration group by SectionNo having semester = 'I-2008';

6) List the course available. Group them by course prefix, e.g. ISM.
->select count(courseName) from course group by courseID having courseID = 'ISM%';

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

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