Changes between Version 6 and Version 7 of Напредни извештаи од базата (SQL и складирани процедури)

Timestamp:

02/01/25 20:28:28 (3 weeks ago)

Author:

201205

Comment:

--

Напредни извештаи од базата (SQL и складирани процедури)

@@ -36 +36 @@
         select count(*) 
         from FriendRequest fr
-        where (fr.SenderId=u.UserId or fr.ReceiverId=u.UserId) 
-        and fr.Status='Accepted'
+        where (fr.SenderId=u.UserId or fr.ReceiverId=u.UserId) and fr.FriendshipStatus='Accepted'
     ), 0) as NumberOfFriends,
     coalesce((
@@ -103 +102 @@
 
 with BookSwapCount as(
-        select b.Title, extract(year from t.BorrowDate) as SwapYear, count(tb.BookId) as SwapCount
+        select b.Title, extract(year from t.BorrowDate) as SwapYear, count(eb.BookId) as SwapCount
         from Transaction t join ExchangingBook eb on t.TransactionId=eb.TransactionId
                 join Book b on eb.BookId=b.BookId