6.23 Slide #55

/* slide#55 COUNT distinct rows */
SELECT  quantity * price AS EP, extendedprice
FROM    ORDER_ITEM 
;

TABLE6.29: 7 records

EP	extendedprice
300	300
200	200
100	100
100	100
50	50
300	300
130	130