DEV Community

DixitAman10
DixitAman10

Posted on

SQL QUERY, can someone solve?

Tables
Image description
Output
Image description
write a query that returns 1st,2nd and 3rd place finishers in each category in that order. The columns are category,student_id,name,college_name and score order by category,college_name asc.

Discussion (0)