fix my SQL code

Create table Order (

OrderNum INT NOT NULL

CustID

ShippingStreet

ShippingCity

ShippingState

ShippingZip

OrderDate

DeliveryChange

PaymentInformation

CreditConfirmation

CONSTRAINT OrderNum PRIMARY KEY

CONSTRAINT FOREIGN KEY

 

Transcribed Image Text:

Home Insert Draw Page Layout ✰ 1 2 J24 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 AutoSave OFF BES 5 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 V Paste X P Ready A X A B orderNum custID 1001 C10 1002 C50 1003 C20 1004 C30 1005 CAO 1006 C100 1007 C90 1008 C70 1009 C140 1010 C90 1011 C80 1012 C60 1013 C20 1014 C90 1015 C60 1016 C70 1017 C90 Drone Calibri (Body) BIU fix C shippingStreet Michigan Ave. Main St. Second St. Main St. Park Ave. Keen Oak Way Lake St. Oak St. Jackson Drive Lake St. Washington Blvd. University Place Second St. Lake St. University Place Oak St. Lake St. Customer ✓ 11 Formulas Data Review View Tell me Order V A A A✓ === ≡≡≡ Delivery D E F G H I OH OH 41073 2020-12-26 41073 2021-1-8 45469 2021-1-10 IL shippingCity shippingState shippingZip orderDate deliveryCharge paymentinformation Dayton Cincinnati Dayton OH Cincinnati OH Dayton OH Chicago Dayton OH Cincinnati OH Chicago IL Dayton OH Dayton OH Cincinnati OH Dayton OH Dayton OH Cincinnati OH Cincinnati OH Dayton OH 41073 2021-1-18 45469 2021-2-3 60601 2021-2-18 45469 2021-2-25 41073 2021-3-2 60603 2021-3-11 45469 2021-3-15 45469 2020-4-10 41073 2020-4-16 45469 2020-5-3 45469 2020-5-11 41073 2020-5-12 41073 2020-5-26 45469 2020-5-26 Store ab Wrap Text Products Merge & Center ✓ 24.99 credit 14.99 credit 24.99 credit 24.99 cash 24.99 credit 14.99 credit 14.99 cash 24.99 cash 14.99 credit 14.99 credit 24.99 cash Dataset_EP-updated 14.99 credit 24.99 credit 14.99 credit 14.99 credit 24.99 credit 14.99 credit OrderLine + General $ % 9 V J CreditConfirmation BCD85XYZ ABC34XYZ BCD34XYZ BCD52XYZ ABC24XYZ ABC64XYZ ABC86XYZ ABC55XYZ BCD48XYZ ABC93XYZ ABC72XYZ BCD68XYZ ABC17XYZ .00 .00 →.0 K Conditional Format Cell Formatting as Table Styles L U M N O Insert v Delete v Format v P Q Σ Share 28. 0. 3 Ideas Sort & Filter Find & Select R B E S T U Qa Comments Sensitivity V 100% Home Insert Draw Page Layout ✰ 1 2 J24 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 AutoSave OFF BES 5 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 V Paste X P Ready A X A B orderNum custID 1001 C10 1002 C50 1003 C20 1004 C30 1005 CAO 1006 C100 1007 C90 1008 C70 1009 C140 1010 C90 1011 C80 1012 C60 1013 C20 1014 C90 1015 C60 1016 C70 1017 C90 Drone Calibri (Body) BIU fix C shippingStreet Michigan Ave. Main St. Second St. Main St. Park Ave. Keen Oak Way Lake St. Oak St. Jackson Drive Lake St. Washington Blvd. University Place Second St. Lake St. University Place Oak St. Lake St. Customer ✓ 11 Formulas Data Review View Tell me Order V A A A✓ === ≡≡≡ Delivery D E F G H I OH OH 41073 2020-12-26 41073 2021-1-8 45469 2021-1-10 IL shippingCity shippingState shippingZip orderDate deliveryCharge paymentinformation Dayton Cincinnati Dayton OH Cincinnati OH Dayton OH Chicago Dayton OH Cincinnati OH Chicago IL Dayton OH Dayton OH Cincinnati OH Dayton OH Dayton OH Cincinnati OH Cincinnati OH Dayton OH 41073 2021-1-18 45469 2021-2-3 60601 2021-2-18 45469 2021-2-25 41073 2021-3-2 60603 2021-3-11 45469 2021-3-15 45469 2020-4-10 41073 2020-4-16 45469 2020-5-3 45469 2020-5-11 41073 2020-5-12 41073 2020-5-26 45469 2020-5-26 Store ab Wrap Text Products Merge & Center ✓ 24.99 credit 14.99 credit 24.99 credit 24.99 cash 24.99 credit 14.99 credit 14.99 cash 24.99 cash 14.99 credit 14.99 credit 24.99 cash Dataset_EP-updated 14.99 credit 24.99 credit 14.99 credit 14.99 credit 24.99 credit 14.99 credit OrderLine + General $ % 9 V J CreditConfirmation BCD85XYZ ABC34XYZ BCD34XYZ BCD52XYZ ABC24XYZ ABC64XYZ ABC86XYZ ABC55XYZ BCD48XYZ ABC93XYZ ABC72XYZ BCD68XYZ ABC17XYZ .00 .00 →.0 K Conditional Format Cell Formatting as Table Styles L U M N O Insert v Delete v Format v P Q Σ Share 28. 0. 3 Ideas Sort & Filter Find & Select R B E S T U Qa Comments Sensitivity V 100%

Answer rating: 100% (QA)

It appears that your SQL code fragment for creating an Order table is incomplete as it lacks the data type definitions for various columns and proper ... View the full answer