Optimizing a DB Query
First visible improvement (assuming that there is no date_awarded values in future) is
WHERE date_awarded &gt;= DATE_FORMAT(CURRENT_DATE, '%Y-%m-01')

Second - the index by (subscription_id, date_awarded, coins) (or maybe (date_awarded, subscription_id, coins), depends on table statistic, must be tested).