PRODUCT_PRICES

Columns

Column	Datatype	Nullable	Insertable	Updateable	Deletable	Comment
CATEGORY_ID	NUMBER(2,0)	Y	NO	NO	NO
#_OF_PRODUCTS	NUMBER(,)	Y	NO	NO	NO
LOW_PRICE	NUMBER(,)	Y	NO	NO	NO
HIGH_PRICE	NUMBER(,)	Y	NO	NO	NO

Query

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