Homework 5 task 3 - Hilari/Tarkvaratehnika-projekt GitHub Wiki

Query that returns the most popular product name, total quantity, unit price and unit price multiplied by the total quantity sold (most popular one is the one that gave highest income – last column max number)

SELECT TOP 1 SOLDITEM.NAME as Toode,
SUM(SOLDITEM.QUANTITY) as Kui_palju,
SOLDITEM.ITEMPRICE as Hind,
SUM(SOLDITEM.QUANTITY*SOLDITEM.ITEMPRICE) as Summa FROM SOLDITEM
GROUP BY SOLDITEM.NAME, SOLDITEM.ITEMPRICE
ORDER BY Summa desc;

Query that returns the date with the highest income (should return only one row).

SELECT TOP 1 CAST(SALE_TIME as DATE) as DATE, SUM(QUANTITY*ITEMPRICE) as SUMMA
FROM SOLDITEM, ORDER
WHERE ORDER.ID=SOLDITEM.SALE_ID
GROUP BY DATE
ORDER BY SUMMA desc;