10.31MySQL作业 102页

1.SELECT * FROM bookinfo WHERE   B_Name like '%C#%';
2.SELECT* FROM bookinfo WHERE  B_Publisher='清华大学出版社' AND B_Date > 2014-07-01;
3.SELECT * FROM bookinfo  ORDER BY B_MarketPrice DESC , B_Date ASC;
4.SELECT SUM(O_TotalPrice) FROM orders GROUP BY O_UserName;
5.SELECT SUM(O_TotalPrice) FROM orders GROUP BY O_Time ORDER BY SUM(O_TotalPrice) ;
6.SELECT * FROM orders s,users c WHERE s.O_UserName = c.U_Name;
7.UPDATE orders SET O_Status =2;  SELECT * FROM orders;