FIND TOP 3 students from math_11a table

The solution for “FIND TOP 3 students from math_11a table” can be found here. The following code will assist you in solving the problem.

select concat(first_name,” “,last_name) as “top_3_leaders”
from Students
inner join
(select student_id, sum(grades) as total from grades
group by student_id
order by sum(grades) desc
limit 3
) as t1
where students.student_id = t1.student_id

Thank you for using DeclareCode; We hope you were able to resolve the issue.

More questions on [categories-list]

0
inline scripts encapsulated in