Write single-table SQL queries to answer the following questions: 1) How many st

Question

Write single-table SQL queries to answer the following questions:
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 Semester 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) select students from section 2714 where year = '2008';

2)select faculty id,course,date of qualification from faculty where year > 1993;

3)select *course from section table;

4)select studentname from students orderby ascending;

5)SELECT section_id FROM enrollment WHERE TRUNC(enroll_date) > TO_DATE('2/16/2008', 'MM/DD/YYYY')

GROUP BY section_id;

6)select *course from coursetable group by course id;

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

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