OE.PRODUCT PRICES (view)
wikibot
View | OE.PRODUCT_PRICES |
Source
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