How many bookings are there?
select count ( * ) from bookings
How many different statuses are used on those bookings?
select count ( distinct status_code ) from bookings
Which of those statuses is used most commonly?
select status_code from bookings group by status_code order by count ( * ) desc limit 1