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.
SQL Code: pointofinterest locations in each Town Solution
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
