A hotel chain stores guest records in a guests table with co…
A hotel chain stores guest records in a guests table with columns for guest_id, full_name, email, and country. If a manager wants to view all the information for every guest, what query should be used? SELECT guest_id, full_name, email, country FROM guests SELECT * FROM guests SELECT ALL FROM guests SELECT everything FROM guests Answer: SELECT * FROM guests Explanation: The * wildcard selects all fields in the table. Listing all columns individually works but is less efficient. SQL does not use ALL or everything as valid keywords in this context.