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 trialAlejandro Romero Parra
1,593 PointsGET a Bummer IDK why
SELECT Name FROM Fruit WHERE Name <"K" UNION SELECT Name FROM Vegetable WHERE Name <"K" ORDER BY Name ASC;
this is my code, i think is what they asking for, but still get a bummer. i also try adding like Fruit.Name and even add the IDs columns and still nothing, i dont really can see the problem here.
1 Answer
Charlie Harcourt
8,046 PointsHi! You need to select between A and L because it will not include K if you don't do it with L.
select Name FROM Fruit WHERE Name Between 'A' AND 'L' UNION select Name FROM Vegetable WHERE Name Between 'A' AND 'L'
Alejandro Romero Parra
1,593 PointsAlejandro Romero Parra
1,593 Pointsyeah i was missing the "k" ones, that was silly, thanks by the way. :)
Steven Parker
231,184 PointsSteven Parker
231,184 PointsNote that "BETWEEN" would include "L" though you can get by with it this time.
But there's another test you could use that would only include words that come before "L".