. Write SQL queries to answer the following questions:

a. For each course included in the QUALIFIED table, list CourseID and the number of faculty members qualified to teach it.

b. For each section included in the REGISTRATION table, list SectionNo and the number of students registered for it. Include only those sections that have more than one student registered for it.

c. For each course, list CourseID and the number of sections offered during semester II-2018.

Problems and Exercises 5-46 through 5-56 are based on the relations shown in Figure 5-12. The database tracks an adult literacy program. Tutors complete a certification class offered by the agency.

Students complete an assessment interview that results in a report for the tutor and a recorded Read score. Each student belongs to a student group. When matched with a student, a tutor meets with the student for one to four hours per week. Some students work with the same tutor for years, some for less than a month. Other students change tutors if their learning style does not match the tutor’s tutoring style. Many tutors are retired and are available to tutor only part of the year. Tutor status is recorded as Active, Temp Stop, or Dropped.