Write the SQL Command from MS SQL Server to answer the following questions.

There are two assumptions in this database;

All courses start with the prefix of ISM, meaning that this database only capture courses for ISM program.

I-2000 means the first semester of year 2000 and II-2000 means the second semester of year 2000. There are only 2 semesters in a year.

1.What is the name of students that has/have the highest number of sections enrolled?

2.Which course (s) has/have the highest number of student enrolled in I-2001 semester (identify COURSE_ID)? The course that did not have enrollment at all is not included.

3.What is/are the name(s) of instructor(s) who can teach the fewest number of courses and how many courses can they teach?

Faculty_ID Faculty Name Faculty_ID Course ID ate ualifie SM 3100 |Programmi ISM 3113 | 9,188 4756 Collins 5233 Potters SM 3150 Adv Progr ammin ISM 4212 Database 6325 Mayers ISM4930 Networkin M6100 Web Programmin ISM 4930 911199 ISM 6500 Know Mamt ISM8745 Seminar in l Registered emester I-2001 8759 8759 45874 54907 45874 45874 45874 54907 54907 54907 66324 66324 66324 66324 70542 70542 716 1-1999 ISM 2000 2 89754 2724