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

SQL Code: pointofinterest locations in each Town Solution

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

3 × five =