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;