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
Fetch Resort Details

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

nine − 5 =