SELECT sum(收押金) as syj FROM JY_Rent_Rec_Info where 编号 is not null
and 卡号 = like '%%'
and 钥匙编号 like '%%'
and 商品编号 =-1
 and 收费编号 = -1
 and 就餐优惠 >0
 and 处理管理员 =  ''
 AND 租赁收银员 =  ''
AND 租赁时间  BETWEEN '2015-8-8' AND '2015-8-9'
