Refer to the schema. Write a query to display the hotel name along with the type. Display the details in the below format.
Give an alias name as hotel_info
. Sort the result in descending order.
For Example:
Hotel_name - 'A2B'
Hotel_type - 'VEG'
Sample Output:
hotel_info |
---|
A2B is a VEG hotel |
HINT: Use Hotel_details table to retrieve records.
NOTE: Maintain the same sequence of column order, as specified in the question description