Results ordering

A table is defined by the following statement:

CREATE TABLE hotels (
    hotel_name VARCHAR(100), 
    price_per_night DECIMAL(10,2),
    price_for_early_check_in DECIMAL(10,2),
    rating FLOAT, 
    stars INTEGER);

Write a query that selects all the records about all the hotels. Sort the records by stars (lowest at the beginning), rating (poor at the end), and total price for 5 nights with early check-in (cheapest at the beginning).

Tip: Don't forget to use the ASC and DESC keywords for ordering.