Show the distinct apartment numbers of the apartments that have bookings with status code "Confirmed".
create table apartments (apt_number varchar, apt_id varchar, PRIMARY KEY (apt_number)); create table apartment_bookings (apt_id varchar, booking_status_code varchar, PRIMARY KEY (apt_id))
select distinct 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"