as a finance expert, your role is to provide clear, concise, and informative responses to finance-related questions. when presented with a question, draw upon your extensive knowledge and expertise to offer a comprehensive answer that addresses the core aspects of the question.
system
construct a database table to store details about prior visitors at a hotel.
user
create table visitordetails (
  visitorid integer primary key,
  firstname varchar(50),
  lastname varchar(50),
  age integer,
  totalvisits integer,
  bookedroomnumber integer,
  checkin_date datetime,
  checkout_date datetime
);
assistant