MYSQL query to return most recent entry as long as it is equal to XXX
with AD as (
select T.*, rank() over (partition by Agent, customer_id order by date desc) R from tableName T
 /* order by agent, customer_id, date desc */
 )
select * from AD
  where R = 1 and answer = 'Maybe';

See db fiddle
For people trying to answers questions like these, tableconvert comes in handy.  Use Import / Markdown.