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

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