query.rb

class SatisfactionQuery
	def self.execute
		query = <<-SQL.strip_heredoc
SELECT pins.id AS pin_id, pins.satisfaction, procedures.name, surgeons.last_name,
	dense_rank() OVER (
		PARTITION BY procedure_id, surgeon_id
		ORDER BY pins.satisfaction DESC
	) AS sat_rank
FROM pins
INNER JOIN procedures
ON procedures.id = pins.procedure_id
INNER JOIN surgeons
ON surgeons.id = pins.surgeon_id
WHERE satisfaction IS NOT NULL;
		SQL

		results = []
		ActiveRecord::Base.connection.select_all(query).each do |row|
			results << OpenStruct.new(row) unless row.nil?
		end

		results
	end
end