Question: ( 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
Get step-by-step solutions from verified subject matter experts
