Show the apartment numbers of apartments with bookings that have status code both "Provisional" and "Confirmed"
select t2.apt_number from apartment_bookings as t1 join apartments as t2 on t1.apt_id = t2.apt_id where t1.booking_status_code = "Confirmed" intersect select t2.apt_number from apartment_bookings as t1 join apartments as t2 on t1.apt_id = t2.apt_id where t1.booking_status_code = "Provisional"