Fetch Resort Details in SQL

Fetch Resort Details

 Write a query to display the resort name and its manager name for resort located at “JAIPUR”. Sort by resort name.

Fetch Resort Details in SQL
Fetch Resort Details in SQL

SQL Code: Fetch Resort Details Solution

select r.resortname, mg.name from resort r join Manager mg
on r.managerID = mg.managerID where r.townname = 'JAIPUR'
order by 1;

Related:

Leave a Comment

5 × two =