SELECT T1.apt_number FROM Apartments AS T1 JOIN View_Unit_Status AS T2 ON T1.apt_id  =  T2.apt_id WHERE T2.available_yn  =  0 INTERSECT SELECT T1.apt_number FROM Apartments AS T1 JOIN View_Unit_Status AS T2 ON T1.apt_id  =  T2.apt_id WHERE T2.available_yn  =  1
Show the apartment numbers of apartments with unit status availability of both 0 and 1.
SELECT T1.apt_number FROM Apartments AS T1 JOIN View_Unit_Status AS T2 ON T1.apt_id = T2.apt_id WHERE T2.available_yn = 0 INTERSECT SELECT T1.apt_number FROM Apartments AS T1 JOIN View_Unit_Status AS T2 ON T1.apt_id = T2.apt_id WHERE T2.available_yn = 1
select t1 . apt_number from apartments as t1 join view_unit_status as t2 on t1 . apt_id = t2 . apt_id where t2 . available_yn = value intersect select t1 . apt_number from apartments as t1 join view_unit_status as t2 on t1 . apt_id = t2 . apt_id where t2 . available_yn = value
Show the apartment numbers of apartments with unit status availability of both 0 and 1 .