MySQL102中作业

SELECT * FROM `bookinfo`
SELECT * FROM bookinfo WHERE B_Name LIKE 'C#%' #1
SELECT B_Publisher FROM bookinfo WHERE '清华大学出版社' GROUP BY B_Date > '2004-01-01';
SELECT * FROM bookinfo WHERE B_Publisher='清华大学出版社' AND B_Date > '2006-01-01';#2
 
SELECT * FROM bookinfo ORDER BY B_MarketPrice DESC,B_Date ASC#3
 
SELECT SUM(O_TotalPrice),O_UserName FROM orders GROUP BY O_UserName#4
 
SELECT * FROM orderdetails ORDER BY OD_Number*OD_Price DESC
 
SELECT SUM(O_TotalPrice) AS '每天的订单总额',O_Time FROM orders GROUP BY O_Time;
SELECT SUM(O_TotalPrice) AS '每天的订单总额',O_Time FROM orders GROUP BY O_Time ORDER BY SUM(0 totalprice) DESC;
SELECT SUM(O_TotalPrice) AS '每天的订单总额',O_Time FROM orders GROUP BY O_Time ORDER BY '每天的订单总额';#5


 
SELECT * FROM orders WHERE O_UserName LIKE 'lijuan'#6
 
SELECT * FROM orders WHERE O_UserName LIKE '林丽';
UPDATE `orders` SET O_Status='2' WHERE O_UserName='林丽'#7