MySQL P102作业

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';#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 OD_Number*OD_Price AS '每天的订单总额',OD_ID FROM orderdetails GROUP BY OD_ID;SELECT * FROM orderdetails ORDER BY OD_Number*OD_Price DESC#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