Queries Solution

1. Show all information of professor who taught the most classes.

2. What is the most popular major? Use correct aggregate functions to create appropriate measure(s) for popular major.

3. Show all info of female students who took more morning Monday class(es) (before 12:00 pm) than afternoon Monday class(es) (between 12:00 pm and 5:00 pm).

4. Do we have more students who are single than who are married? Must return ‘Yes’ or ‘No’.

5. For each student, display his/her currently taking classes that has the latest start time.
Powered by