CREATE OR REPLACE VIEW OE.PRODUCT_PRICES AS SELECT category_id , COUNT(*) as "#_OF_PRODUCTS" , MIN(list_price) as low_price , MAX(list_price) as high_price FROM product_information GROUP BY category_id
