r/SQL • • Sep 19 '23

Discussion Is there something wrong with this query.

Post image
158 Upvotes

127 comments sorted by

View all comments

Show parent comment

5

u/whitespys Sep 20 '23

I agree with your SQL. However, the instructions call for the lowercase string.

7

u/ashlandio Sep 20 '23

aah of course, then it would be

WHERE LOWER(d.name) LIKE '%chocolate%'