select_collection in Ruby on rails

I was able to solve it as follows ...

In my view

<% @students.each do |student| %>
  <tr>
  <td><%= student['nome'] %></td>
    <td><%= student['matricula'] %></td>
    <td><%= student['sala'] %></td>
    <td><%= student['status']%></td>

    <td><%= link_to 'Edit', edit_student_path(student['id']) %></td>
    <td><%= link_to 'Destroy', student_path(student['id']), method: :delete, data: { confirm: 'Are you sure?' } %></td>

  </tr>
<% end %>

In my Model

def ajustaDadosAluno
    queryRoom = "select s.id AS id,s.name AS nome, s.registration AS matricula, 
    r.description AS sala, si.descricao AS status FROM students s
    INNER JOIN rooms r ON r.id = s.room_id
    INNER JOIN situations si ON s.room_id = si.id"
    retorno= ActiveRecord::Base.connection.execute(queryRoom)
end

In my controller

def index
   #@students = Student.all
  #render :json => @students
  student = Student.new
  @students = student.ajustaDadosAluno
end

Create a scope in the model:

class Situation < Application Record
    #suas validações e parametros

    scope :active, -> { where(status: 'active' }
    scope :inactive -> { where(status: 'inactive' }
end

So you can call in your view:

#pega somente os ativos
<%= select(:student, :status, Situation.active.collect { |c| [ c.descricao, c.id ] }) %>

#pegar somente os inativos
<%= select(:student, :status, Situation.inactive.collect { |c| [ c.descricao, c.id ] }) %>