What are the status of all the bookings?
select distinct status_code from bookings
Which one of them is the most frequent one?
select status_code from bookings group by status_code order by count(*) desc limit 1