Aug 13, 2020 3:41 pm
Write a query to display the cabin id, cabin type, cabin description, number or bedroom, sleep capacity, and its cost. O/p should be sorted on cabin id.
1 Reply
Jun 07, 2021 2:13 pm
Hi Rahul,
Please try this one.
Query:
Write a query to display the cabin id , cabin type, cabin description , number of bedroom, sleep capacity , and its cost. Output should be sorted on cabin id.
select cbn.cabinid, cbn.cabintype, cbn.describe, cbn.bedroomcount, cbn.sleepcapacity, (select rate from cabincost where cabinid=cbn.cabinid) as rate from cabin cbn order by 1;