Version 4 (modified by 4 months ago) ( diff ) | ,
---|
Извештај за проверка на профит од продажба за претходната година со детали за книги и клиенти:
#SQL 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 Betitled ORDER BY TotalProfit DESC;
Note:
See TracWiki
for help on using the wiki.