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
Get step-by-step solutions from verified subject matter experts
