SELECT bibNumber, MIN(date(checkOut)), MAX(date(checkOut))
  FROM spl3.transactions
  GROUP BY bibNumber