SQL Query Example 07191424

Download Solution: Click to Download Solution
Solution File Name: SQLQueryExample07191424.docx
Unzip Password: prestobear.com


########1.Print the name(s) and sid(s) of the student(s) enrolled in more than three classes in Fall 2016.

########2.Find the names of students who are enrolled in the maximum number of classes.

########3.Print the age difference between the oldest and youngest student(s) per department. 
Hints: some MySQL’s built-in functions for calculations on dates could be used to compute a student’s age from his/her date of birth.

########4.Print the name(s) and GPA(s) of student(s) who major in B.S. in Information Technology in the Computer Technology department, attending the program after Fall 2015.  
Note that B.S. in Information Technology, Computer Technology, 2015, and Spring are a degree program, a department name, an attending year, and an attending semester, respectively.

########5.Find the names of students who have not enrolled in any course yet Fall 2016.

########6.For each enterYear value that appears in Students, find the gender value that appears most often. 
For example, if there are more male students enterYear 2011 than female student enterYear 2011, you should print the pair (2011, M).

Add Comment