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