1.updateqr_user_infosetscore=score+50wherelevel=3
2.deletefromqr_user_infowherelevelisnull
3.selecta.*fromqr_order_infoa,qr_user_infobwherea.user_id=b.idandb.name='张三'
4.selectb.name,sum(a.total_amount)总金额fromqr_order_infoa,qr_user_infobwherea.user_id=b.idandcreate_date=curdate()groupbyb.name
