Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select sl.EMPLOYEE_ID, SUM(sp.PRICE - nvl(sp."BUYING PRICE",0)) as profit --into 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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement