create the by_provider named scope
use the by_provider named scope
downcase is happening in the by_provider named scope