SQL query for Rating ASC/DESC

Här ska vi istället kunna söka på hoteller med bäst/sämst rating.

EX.
SELECT RoomID, RoomNumber, RoomSize, RoomRating
FROM AvailableRooms
WHERE .....
ORDER BY RoomRating DESC;

Look for the SQL query or data access layer in the project, likely in a file handling room or hotel data. The issue shows a sample query to order rooms by rating; find where similar queries are built and modify to support ordering by RoomRating ASC/DESC. Test by running the application or any existing database tests to ensure the sorting works correctly.

Written by the indexing model from the issue text.