Write SQL codes to answer the following questions

1.Who is/are the student(s) that had to repeat the same course?

2.How many students that had repeated the same course?

3.List the course ID and number of students enrolled in each course. Then, rank them by enrollment number in descending order.

4.What is/are the name(s) of instructors that might be Mr. Aikens teacher?

5.What is/are the name(s) of students that might be Ms. Hiedis students?

6.How many sections there are for the 6000-leveled course? Note: 6000-leveled course are for example ISM 6100. We assume that all courses in this database start with ISM prefix.

7.List all students and the number of sections that they have enrolled. Students who has never enrolled should also be listed in the result with the number of section = n/a.

8.List all the field names and their data types in the IS_Registered table. In other words, show the structure of IS_Registered table.

9.List the number of students enrolled in each section of a particular semester? Sort the result by semester.

10.Which students (list student ID) enrolled in more than 10 sections in year 2002?

11.Who has enrolled to section 2719 in the semester I- 2001? Use join statement.

12.Use the above answer and convert your syntax to SQL in subquery format.

13.Use the above answer and convert your syntax to SQL in subquery format, using Exists keyword.

14.In the semester I- 2001, which student(s) has enrolled ISM 4212 and not enrolled ISM 4390.

15.Which student(s) has/have enrolled more than 4 classes in second semester of 2001? (List their names)

Note: First semester of 2001 is I-2001. Second semester of 2001 is II-2001.

16.Which student(s) has/have enrolled in 6000 leveled courses in the first semester in year 1999? (list their names) We assume that all courses in this database start with ISM prefix.

17.What is the largest numbers of courses that a student enrolled in the first semester of year 2001?

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