Cacher is the code snippet organizer for pro developers

WITH A AS (select PC.price from PRODUCT P,PC WHERE P.MODEL=PC.MODEL AND P.MAKER='A'
UNION ALL
SELECT L.PRICE FROM PRODUCT P, LAPTOP L WHERE P.MODEL=L.MODEL AND P.MAKER='A')

SELECT AVG(PRICE) FROM A


SELECT AVG(PRICE) FROM (select PC.price from PRODUCT P,PC 
WHERE P.MODEL=PC.MODEL AND P.MAKER='A'
UNION ALL 
SELECT L.PRICE FROM PRODUCT P, LAPTOP L WHERE P.MODEL=L.MODEL AND P.MAKER='A') B




#Union will remove duplicates 
#Union all will keep duplicates
###############################union will mess up the order!!!!!