Question:
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.

Code:
Main.sql
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;