pointofinterest locations in each Town
Write a query to fetch the various pointofinterest locations in the town. Display townname,state ,description as “Tourist Spots”, in the ascending order of townid.
select t.townname, t.state, p.describe as "Tourist Spots"
from town t join pointofinterest p
on t.townid=p.townid
order by t.townid;
Related:
- Review Comments Shared by Guest in SQL
- Maximum amount paid by Guest in SQL
- Payments made by Guest in SQL
- Fetch Resort Details in SQL
- Review Comment for all Resort in SQL
- Review Comment for star rating Resort in SQL
- Resort that charges the highest in SQL
- Cities having Summer Temperature More than Jaipur in SQL
- PointOfInterest Locations in Chennai in SQL
- Resort with Least Capacity in SQL
- Guest who paid highest charges in SQL
- Guest details and Total Charges paid in SQL
- Create View_BMS in SQL
