pointofinterest locations in each Town in SQL

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
pointofinterest locations in each Town

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;

Related:

Leave a Comment

13 − seven =