search for: royalty_curr

I want to convert following query into pure ruby one i.e. by using find @us_state_sales=SalesReport.find_by_sql("SELECT z.state, sum(s.royalty_price) as royalty_price, sum(s.units) as units FROM sales_reports s, zip_codes z WHERE royalty_currency = ''USD'' && z.zip_code=s.postal_code GROUP BY z.state ORDER BY royalty_price desc LIMIT 10") i try something like this @us_state_sales1=SalesReport.find(:all, :select=>" zip_codes.state, sum(sales_reports.royalty_price) as royalty_price, sum(sales_r...