ORDER BY clause

Report a typo

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.

Select one option from the list
___

Create a free account to access the full topic