Added a delete statement to remove old room information after leaving.