get demand at appliance level - one db connection