Write a sql query resort located In jaipur display the resort name and the manager Name

Last Post

RSS

Posts: 17

Rahul Updhyay

Topic starter

Aug 13, 2020 3:47 pm

(@rahul)

Active Member

Joined: 4 years ago

Write a query to display the resort name and its manager name for the resort located at jaipur. sort by resort name.

This topic was modified 3 years ago by KV Kumar

Topic Tags

resort jaipur manager sql query sort name

1 Reply

Posts: 36

FA User

Guest

Aug 21, 2020 11:50 am

(@FA User)

Eminent Member

Joined: 4 years ago

Here is the query to display the resort name and its manager name for the resort located at jaipur order by the resort name.

Select a.ResortName, b.name as ManagerName
From
Resort a,
Manager b
Where
a.managerID=b.managerID
AND
b.city= "JAIPUR"
Order by ResortName

This post was modified 3 years ago 3 times by KV Kumar