How can I do the equivalent to this mysql in rails

My query is mysql is as follows:

SELECT SUM(nbdownloaded) FROM (
SELECT field1, field2, nbdownloaded
FROM mytable
Where .... 
 ) as reports

Thank you