Databases Querying Relational Databases Set Operations Set Operations

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";

2 Answers

54,339 Points

You will want to use

 Name < "L"

to include fruits and vegetables that begin with K

It worked, thanks.