Need help fixing a constraint for a DB as well as the test of the constraint.

Tables:

Constraint I tried creating:

ALTER TABLE ORDERS add constraint check_shipping_date SHIP_DATE >= ORDER_DATE;

Need to get constraint fixed (invalid datatype) and need script to verify constraint works.

E- CUSTOMERS CUSTOMERID - CUSTOMER-NAME CUSTOMER-SEGMENT CUSTOMERCOUNTRY CUSTOMER CITY CUSTOMER STATE CUSTOMERPOSTALCODE - - - CUSTOMER REGION ]ORDER ITEMS ORDER ID PRODUCT ID CATEGORY SUBCATEGORY PRODUCT NAME - SALES QUANTITY DISCOUNT PROFIT ..ORDERS ORDER-ID ORDER-DATE SHIP. DATE SHIP MODE CUSTOMERID - SHIP-TO-COUNTRY SHIP-TO CITY SHIP-TO STATE SHIPTOPOSTALCODE SHIP-TO REGION - - - RETURNS ORDER NUMBER REASON