如何在入住和退房之间检查可用性房间预订？

need your help to check availability on room reservation. for the ilustration I have a tabel which have 3 coloumns such as room_number (varchar), check_in (date), check_out (date).need your help to check availability on room re