Displaying 1 result from an estimated 1 matches for "weezer".
Did you mean:
weeber
2009 Apr 16
0
how to convert the find_by_sql code to the find code
...s.royalty_price) as royalty_price,
sum(sales_reports.units) as units FROM `sales_reports` zip_codes WHERE
(download_date BETWEEN ''2010-01-01 00:00:00'' AND ''2010-12-31 00:00:00''
&& artist_name in ("Coconut Records","Reeve Oliver","Weezer") &&
royalty_currency = ''USD'' && zip_codes.zip_code=s.postal_code) GROUP BY
zip_codes.state ORDER BY royalty_price desc LIMIT 10
Regards,
Salil
--
Posted via http://www.ruby-forum.com/.
--~--~---------~--~----~------------~-------~--~----~
You received...