Changes between Initial Version and Version 1 of P4

Timestamp:

01/27/24 14:18:16 (5 months ago)

Author:

216091

Comment:

--

P4

@@ +1 @@
+'' '''Извештај за проверка на профит од продажба за претходната година со детали за книги и клиенти:''' ''
+{{{SELECT 
+    B.Title AS BookTitle,
+    SUM(O.TotalAmount) AS TotalProfit
+FROM 
+    Book B
+JOIN 
+    OrderTable O ON B.BookID = O.OrderID
+WHERE 
+    EXTRACT(YEAR FROM O.OrderDate) = EXTRACT(YEAR FROM CURRENT_DATE) - 1
+GROUP BY 
+    B.Title
+ORDER BY 
+    TotalProfit DESC;
+}}}