PointOfInterest Locations in Chennai in SQL

Question:

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.

Code:

Main.sql

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;

Recommended: