Qtr No. 213, New Town Yehlanka Indore 454775
Rose would like to display names of students whose average marks is greater than 79. She had come up with the below query which has some errors. Help her to modify the query which will give the expected output.
select student_name from students having marks > 79;
students:
student_name | course_name | marks
---------------------+--------------------+-------
Ben | Mathematics | 90
Jack | English | 75
Ben | English | 70
Jack | Mathematics | 65
Kelly | Mathematics | 80
Excepted output:
student_name
--------------------
Ben
Kelly
Select student_name from students group by(student_name) having average(marks)>79;
Select student_name from students where avg(marks)>79;
Select student_name from students group by(student_name) having avg(marks)>79;
Select student_name from students where average(marks)>79;
To get all Infosys Certified PostgreSQL Associate Exam questions Join Group https://bit.ly/infy_premium_group
We're passionate about offering best placement materials and courses!! A one stop place for Placement Materials. We daily post Offcampus updates and Placement Materials.
Qtr No. 213, New Town Yehlanka Indore 454775
admin@prepflix.in
