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
);
Now have a look at the following query:
SELECT
hotel_name,
2 * price_per_night + price_for_early_check_in AS price,
rating,
stars
FROM
hotels
???
;
Choose the correct syntax to put instead of ??? to order selected data by stars and price per night.