Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

Databases Querying Relational Databases Set Operations Set Operations

Garrett Harriman
Garrett Harriman
4,171 Points
Posted by Garrett Harriman
Garrett Harriman
4,171 Points

Cannot Pass Challenge 2 of 6: SQL Set Operations Review (Fruit and Vegetables)

Hi all,

I'm attempting to pass Challenge 2 of 6 for SQL Set Operations Review (Fruit and Vegetables). The question asks us to create a UNION that shows all fruits and veggies between the letters A and K. I'm using the below code. I ran in SQL Playground under different variables and it worked, but it's not working here:

SELECT Name FROM Fruit
    WHERE Name < "K"
UNION
SELECT Name FROM Vegetable
    WHERE Name < "K";

I saw that another student about 1 year ago also posted a question with similar results (she used BETWEEN "A%" AND "K%"). How can I pass this question to continue ASAP? Thank you!

2 Answers

jb30
jb30
44,807 Points

Instead of Name < "K", try Name < "L" to include names that start with "K" in the result.

Garrett Harriman
Garrett Harriman
4,171 Points
Garrett Harriman
Garrett Harriman
4,171 Points

Thank you very much, that was the ticket :)