PointOfInterest Locations in Chennai in SQL

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.

PointOfInterest Locations in Chennai
PointOfInterest Locations in Chennai

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:

Leave a Comment

5 + seventeen =