Display Tourist Spots in SQL

Question:

Display Tourist Spots

Guest has requested the manager to give the list of point of interest which closes 8PM or later. Write a query to display the point ID and its description. Display  the output  in the ascending order of pointid.

Quiz for Exam - Display Tourist Spots

Code:

Main.sql

select pointID, describe 
from pointofinterest 
where closetime >='8PM' 
order by pointID;

Recommended:

Leave a Comment

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

x