SQL统计哪种类型的书借出最多

书籍的信息在Book5库里面，借阅的记录在Borrow1里面，将两个表连接之后又无法用以下的代码：
select CONVERT(varchar,cno,120),count() as 'number'from Borrow1
where borrow_date>'2021-2-17' group by Convert(varchar,cno,120)
order by count() desc
来进行计数，希望大家的指点。

这样？

select booktype,COUNT(1) borrownum from borrow1
left join book5 on book5.id=borrow1.bookid
group by booktype
order by borrownum desc

你倒是给点报错信息

-- a.id 为书籍主键 bookNo 书籍编号 bookName 书籍名词
-- Borrow1 表有书籍id字段

select a.id,min(a.bookNo) bookNo,min(a.bookName) bookName,,a,count(b.id) as 'number'
from Book5 a
left join Borrow1 b on b.bookId=a.id
where borrow_date>'2021-2-17' group by a.id
order by count() desc
```sql

```

您好，我是有问必答小助手，您的问题已经有小伙伴帮您解答，感谢您对有问必答的支持与关注！
PS：问答VIP年卡 【限时加赠：IT技术图书免费领】，了解详情>>> https://vip.csdn.net/askvip?utm_source=1146287632