Homework 5 - Tonnius/Tiim14-50 GitHub Wiki

#SQL queries

Esimene käsk:

SELECT NAME AS "Name", SUM(QUANTITY) AS "Total quantity", ROUND( MEDIAN( PRICE ), 2) AS "Unit price", ROUND( SUM( QUANTITY * ITEMPRICE ), 2) AS "Unit price multiplied by the total quantity sold" FROM "PUBLIC"."SOLDITEM" JOIN "PUBLIC"."STOCKITEM" ON SOLDITEM.STOCKITEM_ID = STOCKITEM.ID GROUP BY NAME ORDER BY ROUND( SUM( QUANTITY * ITEMPRICE) ) DESC LIMIT 1

Teine käsk:

SELECT CAST( TIME AS DATE) AS "Date", ROUND( SUM( SALE_SUM ), 2) AS "Income that day" FROM "PUBLIC"."SALES" GROUP BY CAST( TIME AS DATE) ORDER BY ROUND( SUM( SALE_SUM ), 2) DESC LIMIT 1