Needs to be done in MySQL

Students making average progress in their courses of less than 50% need to be offered tutoring assistance.

Write a query to list First Name, Last Name and Average Progress of all students achieving average progress of less than 50%.

The average progress as displayed should be rounded to one decimal place.

The output should be sorted by Average Progress in descending order, then by First Name in ascending order, then by Last Name in ascending order

department Column Name id Allow Nulls Data Type Allow Nulls DataType int varchar(30) course Column Name id name deptid int name varchar(50) int Allow Nulls faculty Column Name id firstname lastname deptid DataType int varchar(30) varchar(50) int Data Type Allow Nulls studentCourse Column Name studentld 9 courseld progress startDate int int int Allow Nulls date student Column Name rid firstname lastname street Data Type int varchar(30) varchar(50) varchar(50) varchar(30) varchar(30) varchar(30) char(5) int street Detail state Data Type Allow Nulls facultyCourse Column Name od facultyd courseld int postalCode majorld oc int oo