|
OE |
||||||||||||
|
Description Columns Query Constraints Referenced by Triggers |
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 |
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