sql优化，求高人赐教，不胜感激
sql:
select mainMPRuleID ,
date_format(statetime, ‘%Y-%m-%d’) statetime ,
sum(TradeCount) TradeCount ,
sum(TradeCountSucc) TradeCountSucc ,
sum(TradeCount) – sum(TradeCountSucc) as TradeCountFail ,
round(sum(TradeCountSucc) * 100 / sum(TradeCount), 2) as TradeRateSucc ,
sum(UserCount) UserCount ,
sum(UserCountSucc) UserCountSucc ,
sum(UserCount) – sum(UserCountSucc) as UserCountFail ,
round(sum(UserCountSucc) * 100 / sum(UserCount), 2) as UserRateSucc ,
sum(Income / 100) as Income
from t_yx_trade_stat
where 1 = 1
and mainMPRuleID = ‘MP20110729104637218’
and statetime < ‘2013-01-01’
and statetime >= ‘2011-07-29’
group by mainMPRuleID, statetime order by statetime
表结构是：
+——————-+————–+——+—–+————+——-+
| Field | Type | Null | Key | Default | Extra |
+——————-+————–+——+—–+————+——-+
| MPRuleID | varchar(128) | NO | PRI | | |
| PayChannel | varchar(32) | NO | PRI | | |
| ServiceCode | varchar(64) | NO | PRI | | |
| Discount | varchar(50) | NO | PRI | | |
| Buynum | varchar(255) | NO | PRI | | |
| TradeCount | int(12) | YES | | NULL | |
| FirstPriceIncome | int(12) | YES | | NULL | |
| FirstPriceSucc | int(12) | YES | | NULL | |
| FirstPriceFail | int(12) | YES | | NULL | |
| SecondPriceIncome | int(12) | YES | | NULL | |
| SecondPriceSucc | int(12) | YES | | NULL | |
| SecondPriceFail | int(12) | YES | | NULL | |
| Income | int(12) | YES | | NULL | |
| ProvideSucc | int(12) | YES | | NULL | |
| ProvideFail | int(12) | YES | | NULL | |
| PresentSucc | int(12) | YES | | NULL | |
| PresentFail | int(12) | YES | | NULL | |
| UserCount | int(12) | YES | | NULL | |
| UserCountSucc | int(12) | YES | | NULL | |
| TradeCountSucc | int(12) | YES | | NULL | |
| StateTime | date | NO | PRI | 0000-00-00 | |
| GroupsID | varchar(64) | NO | PRI | | |
| bu | varchar(128) | YES | | NULL | |
| department | varchar(128) | YES | | NULL | |
| type | varchar(128) | YES | | NULL | |
| product | varchar(128) | YES | | NULL | |
| mainMPRuleID | varchar(128) | YES | | NULL | |
| serviceGroupID | varchar(128) | YES | | NULL | |
| DiscountStr | varchar(128) | YES | | NULL | |
| BuynumStr | varchar(128) | YES | | NULL | |
| ServiceGroupCode | varchar(64) | YES | | NULL | |
| ServiceGroupName | varchar(64) | YES | | NULL | |
| name | varchar(128) | YES | | NULL | |
