Question: SUPPUER: - SUP_ID: Supplier ID, INTEGER - SUP_ NAME: Supplier name, VARCHAR DEPARTMENT: - SUP_PHONE: Supplier phone number, - DEPT_ID. Department ID, INTEGER VARCHAR -

SUPPUER: - SUP_ID: Supplier ID, INTEGER - SUP_ NAME: Supplier name, VARCHAR DEPARTMENT: - SUP_PHONE: Supplier phone number, - DEPT_ID. Department ID, INTEGER VARCHAR - DEPT_NAME; Department name, - sup_state: Supplier state, VARCHAR VARCHAR IIEM: - DEPT_PHONE: Department - ITEM_ID: item ID, INtEgER - IEM-DESC: Item description, DELNERY: - ItEM_PRICE: Item's Current - DR_id. Delivery ID, NUMBER - ITEM_PRICE: Item's Current - DR_QUANTIIYY: Delivery - ITEM_QOH: Item quantity on Quantity (ordered quantity), hand, NUMBER - ITEM_MIN: item minimum - DE_PRICE: Delvery price (the required inventory, NUMBER the order. It is stored to main SALE: historical data), NUMBER - SALE_DATE: Date of sale, DATE Please consider the database and metadata above. The company provides a 30-day warranty for items when an item is sold. When 30 days pass over the item sale date, the warranty expires - display the item id, sale date, and a calculated column to find the item expiration date
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
