Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Programming Languages 12th International Symposium Dbpl 2009 Lyon France August 2009 Proceedings Lncs 5708

Authors: Philippa Gardner ,Floris Geerts

2009th Edition

3642037925, 978-3642037924

Students also viewed these Databases questions