Question

write a program to accept the name of two laptops and their pieces.Find and print the total cost​

Answer 1

SELECT EMP_NUM, EMP_LNAME, EMP_FNAME, Sum(INV_TOTAL) AS TOTALINVOICES FROM LGINVOICE, LGEMPLOYEE WHERE EMP_NUM = EMPLOYEE_ID GROUP BY EMP_NUM, EMP_LNAME, EMP_FNAME ORDER BY EMP_LNAME, EMP_FNAME