Example Rails 3 Scopes for reference

scopes.rb

scope :scope, where("column=value") 
  scope :scope_with_input, lambda { |value| where("column =?", value)} 
  scope :cope_with_join_and_input, lambda { |value| joins(:other_table).where("other_table.other_table_column =?", value)}