Need help on returning fruits and vegetables with letters A to K - Task 2 challenge
When am running this, i am getting a message that UNION query has not returned letters A to K. Below is my code
SELECT Name FROM Fruit WHERE Name < "K" UNION SELECT Name FROM Vegetable WHERE Name < "K";
KRIS NIKOLAISEN54,339 Points
You will want to use
Name < "L"
to include fruits and vegetables that begin with K
It worked, thanks.