Call Support +91-85588-96644
TCYonline

Login

Sign Up

Please enter a Username or Email ID
Please enter a password
Keep me logged in
Please enter your name
Please enter your mobile number
You can't leave Captcha Code empty
By submitting this form, you agree to the Terms & Privacy Policy.
OR

Sign Up via Facebook

Sign Up via Google

Sign Up via Twitter

Download Software
Tests given

Download TCY App

App Image

The STUDENT_GRADES table has the following columns:
STUDENT_ID NUMBER (12)
SEMESTER_END DATE
GPA NUMBER (4, 3)

Which of the following statements finds the highest Grade Point Average (GPA) per semester?

 
SELECT MAX(gpa) FROM student_grades WHERE gpa IS NOT NULL;
SELECT (gpa) FROM student_grades GROUP BY semester_end WHERE gpa IS NOT NULL;
SELECT MAX(gpa) FROM student_grades WHERE gpa IS NOT NULL GROUP BY semester_end;
SELECT MAX(gpa) GROUP BY semester_end WHERE gpa IS NOT NULL FROM student_grades;
SELECT MAX(gpa) FROM student_grades GROUP BY semester_end WHERE gpa IS NOT NULL;

Reply


Please type your answer before submitting.
Submit

SELECT MAX(gpa) FROM student_grades WHERE gpa IS NOT NULL GROUP BY semester_end;

@Lakshmi --> No, Group by clause can never come before Where clause. The sequence is SELECT, FROM, WHERE, GROUP BY, HAVING

Please suggest if the last option will work the same way as the third option??