SELECT building, room_number FROM classroom WHERE capacity BETWEEN 50 AND 100
Temukan jumlah kamar kamar yang dapat duduk 50 hingga 100 siswa dan bangunan mereka.
CREATE TABLE classroom (building VARCHAR, room_number VARCHAR, capacity INTEGER)