Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started