SELECT * FROM TWS2F14CCC260D71 WHERE 地类='1999资源清查有林地'
1、Alter table LOANS add [备注说明] varchar(20)。
2、Select 出版社,KCSL as 库存量,总价/KCSL as 平均单价 From (Select 出版社,count(索书号) as KCSL,sum(价格) as 总价 from BOOKS Group by 出版社) As 库存表 Order by 库存量 Desc。
3、Select Left(借书证号,2) as 年级,Count(*) as 人数 from BORROWER Order by 年级。
4、Select 出版社 from BOOK Where 价格>200 group by 出版社。
5、Select 借书证号,Count(图书登记号) As 借书数量 from LOANS Group by 借书证号 having Count(图书登记号) >5 order by 借书证号 Desc。