Question: SUPPUER: - SUP_ID: SUpplier ID, INTEGER - SUP_NAME: Supplier name, VARCHAR DEPARTMENT: - SUP_PHONE: Suppller phone number, - DEPT_ID: Department ID, INTEGER VARCHAR VEPT_NAME: Department

 SUPPUER: - SUP_ID: SUpplier ID, INTEGER - SUP_NAME: Supplier name, VARCHAR

SUPPUER: - SUP_ID: SUpplier ID, INTEGER - SUP_NAME: Supplier name, VARCHAR DEPARTMENT: - SUP_PHONE: Suppller phone number, - DEPT_ID: Department ID, INTEGER VARCHAR VEPT_NAME: Department name, - SUP_STATE: Supplier state, VARCHAR - DEPT_PHONE: Department IIEM: phone number, VARCHAR - ITEM_ID: Item ID, INTEGER - ITEM DESC: Item description. DELNERY: Price, NUMBER - ITEM_QOH: Item quantity on hand, NUMBER quantity (ordered quantity), - ITEM_MIN: Itern minimum - DE_PRICE; Delivery price the required inventory, NUMBER the order. It is stored to main SALE: historical data), NUMBER - SALE_ID: Sales ID, INTEGER - SALE_DATE: Date of sale, DATE Please consider the database and metadata above. Generate a list of items with less than or equal to the average item price (Hint: Find the items, not average item price). Display all item-related columns

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!