Use Bookgoselect student number =stuid, student name = (SELECT stuname from dbo. STUDENT WHERE stuid = dbo. BORROW.STUID), book number =bid, book name = (SELECT Title from dbo. Book WHERE bid=dbo. Borrow.bid), lent date =t_timefrom dbo. Borrow WHERE Stuid in (SELECT stuid from dbo. STUDENT WHERE major= ' computer ') and T_time > ' 2007-12-15 ' and T_time < ' 2008-1-8 ' select Stuid as student number (select Stuname FRO M dbo. STUDENT WHERE stuid = dbo. BORROW.STUID) as student name, BID as book number, (SELECT Title from dbo. Book WHERE BID = dbo. Borrow.bid) as book name, T_time as loan date from dbo. Borrow WHERE Stuid in (SELECT stuid from dbo. STUDENT WHERE Major = ' computer ') and t_time between ' 2007-10-15 ' and ' 2008-1-8 ' SELECT stuid as student number, stuname as student name, Major as professional FROM dbo. STUDENT WHERE Stuid in (SELECT stuid from dbo. Borrow) Select (select Stuname from dbo. STUDENT WHERE stuid = dbo. BORROW.STUID) as Student name (SELECT Title from dbo. Book WHERE BID = dbo. Borrow.bid) as book name from dbo. Borrow WHERE BID in (SELECT BID from dbo. Book WHERE author= ' Jing Jinnan ') Select (select Stuname from dbo. StUdent WHERE stuid = dbo. BORROW.STUID) as student name, COUNT (*) as borrowing quantity from dbo. Borrow WHERE B_time is the NULL GROUP by Stuid
Student borrowing enquiries