SELECT PS.NAME, COUNT(*) AS "UNITS SOLD", PS.BUYING_PRICE, PS.PRICE, COUNT(*)*(PS.BUYING_PRICE - PS.PRICE) AS PROFIT
FROM SALES S, STOCK STK, PRODUCT_SPECIFICATION PS
WHERE S.PRODUCT_IMEI_NO = STK.STOCK_IMEI AND STK.STOCK_PRODUCT_ID = PS.PRODUCT_ID
AND S.EMPLOYEE_ID = 10
GROUP BY PS.NAME, PS.BUYING_PRICE, PS.PRICE
;