PointOfInterest Locations in Chennai
Write a query to display the pointId, description, open time and close time for all the pointofinterest in “CHENNAI” location. Output should be sorted on pointid.
SQL Code: PointOfInterest Locations in Chennai Solution
select p.pointid, p.describe, p.opentime, p.closetime
from pointofinterest p join town t
on t.townid=p.townid
where t.townname='CHENNAI'
order by 1;Related:
- Review Comments Shared by Guest in SQL
- Maximum amount paid by Guest in SQL
- pointofinterest locations in each Town 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
- 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
