Page History: OE PRODUCT_PRICES (view)
Compare Page Revisions
Page Revision: 2010/02/11 09:19
wikibot
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
References