list using a sql statement

I think it would be worth your while working through some tutorials
and guides. Have a look at the guides at
http://guides.rubyonrails.org/ for a start. Agile Development with
Rails is an excellent book. The tutorial at
http://www.railstutorial.org/ is good. Make sure that any tutorial
you try is for rails 2.3.

For your particular problem I would suggest using named_scope.

Colin