Question: Im using SQL and code is not working, I used another coder and it works there. not sure what is wrong with my work --

Im using SQL and code is not working, I used another coder and it works there. not sure what is wrong with my work

-- create a table for books

CREATE TABLE booklist (

bookid INTEGER PRIMARY KEY,

booktitle TEXT NOT NULL,

book author TEXT NOT NULL,

inventory INTEGER,

wholesale_price DECIMAL(10,2),

retail_price DECIMAL(10,2)

);

INSERT INTO booklist VALUES (1, 'Hello World', 'Smith', 10, 19.50, 25.95);

INSERT INTO booklist VALUES (2, 'How To Paint', 'Moore', 15, 11.95, 18.95);

INSERT INTO booklist VALUES (3, 'World Travel', 'Jones', 12, 15.09, 25.05);

INSERT INTO booklist VALUES (4, 'Happiness', 'McGrath', 7, 45.95, 79.95);

INSERT INTO booklist VALUES (5, 'Dedication', 'Manning', 17, 29.95, 39.95);

INSERT INTO booklist VALUES (6, 'Congratulations', 'Ambrose', 11, 39.95, 50.95);

SELECT * FROM booklist;

Select booktitle, inventory, retail_price

From booklist

Where retail_price > 20.00;

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 General Management Questions!