select sl.EMPLOYEE_ID,(select e.NAME from EMPLOYEES e where e.EMPLOYEE_ID = sl.EMPLOYEE_ID ) as Name, SUM(sp.PRICE - nvl(sp.BUYING_PRICE,0)) as Profit
		from SALES sl, STOCK stk, PRODUCT_SPECIFICATION sp
		where sl.PRODUCT_IMEI_NO = stk.STOCK_IMEI and stk.STOCK_PRODUCT_ID = sp.PRODUCT_ID
		group by sl.EMPLOYEE_ID
		order by sl.EMPLOYEE_ID