sql語句的書

『壹』 sql語句查詢（圖書借閱）

1，查詢所有借過書的學生編號，姓名，專業，？SELECT DISTINCT borrow.stuid, student.major
FROM borrow LEFT OUTER JOIN
student ON borrow.stuid = student.stuID2，借書但是未歸還的學生姓名及該生未歸還書的圖書數量？SELECT student.stuName, COUNT(1) AS Expr1
FROM borrow LEFT OUTER JOIN
student ON student.stuID = borrow.stuid
WHERE (borrow.b_time IS NULL)
GROUP BY student.stuName3，比如書名是《天龍八部》，請分別查詢借過它的人的姓名，借書日期，看了多少天，要考慮若某人借了但是沒還，則在看了多久一欄填上（尚未歸還）SELECT student.stuName, borrow.t_time, CASE WHEN borrow.b_time IS NULL THEN '尚未歸還' ELSE cast(datediff(day,t_time,b_time) as varchar) END AS Expr1
FROM borrow LEFT OUTER JOIN
student ON student.stuID = borrow.stuid LEFT OUTER JOIN
book ON borrow.bid = book.Bid
WHERE (book.title = '天龍八部')