Guest’s Check-In & Check-Out Details in SQL


Guest’s Check-In & Check-Out Details

Write a query to display the guest name, country, email id , phone number , check in date  , check out date  and total amount to be paid. Sort the output in the ascending order of guest id.

Guest's Check-In & Check-Out Details



select,,,, b.fromdate, b.todate, b .totalcharge
from guest g join booking b
on g.guestID=b.guestID
order by g.guestID;


Leave a Comment

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