Hi Order By not working on MySql
the code is as follows,
select * from School where School.type = 'HighSchool'
order by (select locations.name from locations inner join School_locations
on locations.id = School_locations.location_id where
School_locations.School_id = School.id and locations.location_country = 'US' limit 1)
and the output is displaying same for both ascending as well as descending how to solve this problem