edited sql with 50 rooms