Answered step by step
Verified Expert Solution
Question
1 Approved Answer
( begin{array}{ll}text { SUPPUER: } & text { DEPARTMENT: } text { : SUP_ID: SUPPDlier ID, INTEGER } & text { DEPT ID: Department
\( \begin{array}{ll}\text { SUPPUER: } & \text { DEPARTMENT: } \\ \text { : SUP_ID: SUPPDlier ID, INTEGER } & \text { DEPT ID: Department ID, } \\ \text { - SUP_NAME: SUpplier name, VARCHAR } \\ \text { - SUP_PHONE: Supplier phone number, } & \text { INTEGER }\end{array} \) - SUP_PHONE: Supplier phone number, - DEPT_NAME: Department name, - SUP_STATE: Supplier state, VARCHAR VARCHAR IIEM: - DEPT_PHONE: Department - ITEM_ID: Item ID, INTEGER - ITEM_DESC: Item description, - ITEM_PRICE:Item's Current - DEL_QUANTITY:Delivery Price, NUMBER \( \begin{array}{ll}\text { - ITEM_QOH: Item quantity on } & \text { NUMBER } \\ \text { hand, NUMBER } & \text { DEL_PRICE: Delivery price (the }\end{array} \) - ITEM_MIN: Item minimum price of the item at the time of 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. Display a list of the item description, item quantity on hand, supplier id, which is either 1001 or 1005 , and item price, which is less than or equal to $100
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