将SQL查询转换为ActiveRecord并将其呈现为一个表

I am trying to translate a raw SQL query in my model to use ActiveRecord Query Interface. I think that I translated the query correctly, but I cannot transform it to an array in order to render it.I am trying to translate a raw SQL query in my