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