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;