pointofinterest locations in each Town in SQL

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.

pointofinterest locations in each Town

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;

Recommended:

Leave a Comment

Your email address will not be published. Required fields are marked *