Question: CREATE TABLE coffee _ inventory ( sku VARCHAR ( 2 5 5 ) , name VARCHAR ( 2 5 5 ) , roast _ type

CREATE TABLE coffee_inventory (
sku VARCHAR(255),
name VARCHAR(255),
roast_type VARCHAR('Dark','Medium','Light'),
lbs_on_hand DECIMAL(10,2),
organic VARCHAR('Yes','No'),
price_per_lb DECIMAL(10,2)
);

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!