List the students (first name, Last Name and GPA) who were admitted in the year 2015....

  

Transcribed Image Text:

List the students (first name, Last Name and GPA) who were admitted in the year 2015. List the Juniors (first name, Last Name and GPA) who were admitted before the year 2015 3. List the Average GPA by Major (Major code is sufficient). 2. 4. List the Average GPA by College. 5. List the College with the least average GPA. 6. List the students with GPA's higher than the total average GPA. 7. List the Name of the student with the highest GPA. 8. List the college of the student with the highest GPA. 9. List Number of days elapsed since admission for each student. 10. How many majors does each college have. 11. List the maximum GPA by student status. Students ID 101 104 923 489 519 911 636 671 727 453 441 Major Code Freshman 103 FName Lname Status Tom Smith Dori Negrino Horst Keller Sascha Kruger Lisa Miller Toni Gaddis Shawn Lauriat Richard Klein Cathy Peter Eric Sophomore 101 Junior 101 Junior 100 Freshman 101 Senior 103 Freshman 102 Senior 103 100 Manning Freshman Burrows Sophomore 102 Grover Freshman 103 Admitted GPA Date 3.51 3-May-2015 2-Jul-2015 21-Jul-2013 4.00 21-Apr-2014 2.79 21-Oct-2015 3.68 1-Nov-2011 3.93 3-May-2015 3.72 1-Jun-2015 3.92 3.34 3.91 2.98 3.49 3-May-2015 2 Sep 2014 1-Jan-2017 Departments Dept Code 100 101 102 103 Dept Namel Computer Science Business Informatics Mathematics Accounting College INF INF AS COB List the students (first name, Last Name and GPA) who were admitted in the year 2015. List the Juniors (first name, Last Name and GPA) who were admitted before the year 2015 3. List the Average GPA by Major (Major code is sufficient). 2. 4. List the Average GPA by College. 5. List the College with the least average GPA. 6. List the students with GPA's higher than the total average GPA. 7. List the Name of the student with the highest GPA. 8. List the college of the student with the highest GPA. 9. List Number of days elapsed since admission for each student. 10. How many majors does each college have. 11. List the maximum GPA by student status. Students ID 101 104 923 489 519 911 636 671 727 453 441 Major Code Freshman 103 FName Lname Status Tom Smith Dori Negrino Horst Keller Sascha Kruger Lisa Miller Toni Gaddis Shawn Lauriat Richard Klein Cathy Peter Eric Sophomore 101 Junior 101 Junior 100 Freshman 101 Senior 103 Freshman 102 Senior 103 100 Manning Freshman Burrows Sophomore 102 Grover Freshman 103 Admitted GPA Date 3.51 3-May-2015 2-Jul-2015 21-Jul-2013 4.00 21-Apr-2014 2.79 21-Oct-2015 3.68 1-Nov-2011 3.93 3-May-2015 3.72 1-Jun-2015 3.92 3.34 3.91 2.98 3.49 3-May-2015 2 Sep 2014 1-Jan-2017 Departments Dept Code 100 101 102 103 Dept Namel Computer Science Business Informatics Mathematics Accounting College INF INF AS COB

Answer rating: 100% (QA)

Short Summary Provided the Create Insert and Select queries performed on tables Departments and Stud... View the full answer