Write a single SQL query that determines the list of all guests that are CURRENTLY staying at the 'Peach Trees Hotel' today. Because we don't want to both with mid-day check-in/check-outs, we will assume both check-out and check-in happens instantly and happens at midnight. Thus, if the check-out date is "today" then they are still there and don't leave until just before midnight.

Answer rating: 100% (QA)

Answer orders SELECT FROM orders WHERE Salesmanid S... View the full answer