select u.name,date,(select sum(number)from passing_number pn1 where pn1.date<=pn.date and pn1.user_id=pn.user_id) from passing_number as pn,user u where u.id=pn.user_id order by date,u.name