View equipment for each room
Room equipment SQL