最土系统统计某段时间的营业数据

SELECT team_id, COUNT( 1 ) , SUM( quantity ) , sum(money) as 收款, sum(fare) as 物流费 FROM `order` WHERE state = 'pay' AND create_time > UNIX_TIMESTAMP( '2010-12-13 00:00:00' ) and create_time