Computer scienceFundamentalsSQL and DatabasesBasics SQLRetrieving Data

Results ordering

Requirements to statement

Report a typo

Consider the following query:

SELECT
    hotel_name, 
    2 * price_per_night + price_for_early_check_in as price,
    rating, 
    stars
FROM 
    hotels
ORDER BY
    ???
;

Match the sorting requirements with the corresponding ending of the ORDER BY clause.

Match the items from left and right columns

hotels with many stars at the beginning

hotels with low rating at the end

hotels with low price per night at the beginning

hotels with high total price at the end

price_per_night

stars DESC

rating DESC

price

___

Create a free account to access the full topic