Hi Team, I ran the query to get the distinct name from Fruit and Vegetable tables having name starting with A through K

Question

select name from Fruit where name like '[A-Z]%' union select name from Vegetable where name like '[A-Z]%';

Above query seems good to me but not working, Could you please have a look into this?

Answer 1 · 2016-09-20T20:50:00Z

September 20, 2016 8:50pm

Remember you need between A and K. So you need to set it to "A" AND "L".

It will not count K as in between. So you have to make it L instead.

So this should work.

SELECT Name FROM Fruit WHERE Name BETWEEN "A" AND "L" UNION SELECT Name FROM Vegetable WHERE Name BETWEEN "A" AND "L";

Answer 2 · 2016-09-20T20:35:01Z

September 20, 2016 8:35pm

You have to use the BETWEEN keyword here.

Try with that. Reply again if you dont know what the correct code is, i can paste that aswell. But try and give it a go first.

Welcome to the Treehouse Community