Active record query for finding products in each city

Question

I have two models as given below. Address table has an attribute city. Is it possible to find out total no. of products in each city using active record queries or do can it be done only through native sql query?

    class Product < ActiveRecord::Base
      has_one :address
    end

    class Address < ActiveRecord::Base
      has_many :products
    end

Answer 1

use this code:

 @no_of_products= Product.joins(:address).group("adrresses.city").count