the code not respond, does not give input

Question

code practice Online Bookstore
SELECT *
FROM books
WHERE author = 'Fiction'

Answer 1

Read the requirement of that practice code carefully.It is clearly mentioned to extract books with 'Fiction' genre not 'Fiction' author. So why you have used `author`. Replace it with `genre`
So your code should be-

SELECT *
FROM books
WHERE genre = 'Fiction';

Answer 2

it is true that I had not paid attention to this

Answer 3

author = 'Fiction' ???

Answer 4

Review the lesson AMIR H R A<ヾ(@^▽^@)ノ >LION 💪

If you still have trouble, we need to see the task as well.

https://code.sololearn.com/WZ8lkR6gTex6/?ref=app
https://code.sololearn.com/W0uW3Wks8UBk/?ref=app

Answer 5

Doesn't answer

Answer 6

write the query to select the dessert name and place from the desserts table where the dessert name contains the word 'Chocolate'
this practice

Answer 7

thanks Koli that's right I forgot and all guys

Answer 8

write a query to select all fields from the books table but only retrieve the books that belong to the 'Fiction' genre
Online Bookstore practice sql ...

Answer 9

AMIR H R A<ヾ(@^▽^@)ノ >LION 💪
Didn't you just write the hint?
<books that belong to the 'Fiction' genre>

Answer 10

yes

Answer 11

the code not respond does not give input ?
SELECT * FROM desserts
WHERE name LIKE '%Chocolate';
the project of sql Chocolate code

Answer 12

doesn't answer

Answer 13

Try this one bro-
SELECT name,price
FROM desserts
WHERE name LIKE '%chocolate%';

You just forgot to put `%` at the end of the chocolate no need of any uppercase or lowercase and the practice code is asking for extract name and price not all thing!

Answer 14

AMIR H R A<ヾ(@^▽^@)ノ >LION 💪
If you have a new question, pleaes post in a new post.

Prathish K K
I'm not sure if you reached this particular exercise, you suggestion looks logical on the surface but doesn't match the table in question.
Please don't spam with educated guess.

Answer 15

thanks Koli it is true and all guys

Answer 16

Check the table name first

Answer 17

Add semi-colon " ; "at the end bro

Answer 18

To check all the tables use
SHOW TABLES;

The view the whole table once
SELECT * FROM <table_name>;

And then check the corresponding column name and the value you used in the query before

Answer 19

Select dessert_name from desserts where dessert_name = 'Chocolate';

Answer 20

dessert_name is the column name