UNION ALL didn't bring back a union of all fruits and vegies (Querying Relational Databases, Challenge 3 of 6)

Hi,

In the Querying Relational Databases Class, my UNION ALL query didn't bring back a union of all fruits and vegetables.

Here's the question: Challenge 3 of 6:

There are two tables Fruit and Vegetable table. The Fruit table has a FruitID and a Name column and the Vegetable table has a VegetableID and Name column. Create a list of fruits and vegetables that includes any potential duplicate values. Ensure that it is in alphabetical order so that the duplicates are next to each other!

Here's my query:

SELECT Name FROM Fruit UNION ALL SELECT Name FROM Vegetable ORDER BY Name DESC; I got a table listing Zucchini, Zucchino, Yams, Winter Melon

And I got the following error message:

Bummer! Your UNION queries didn't bring back a union of all fruits and veggies (including duplicates).

My query appears to follow the UNION ALL format. I made sure to use the same columns on each side (Name). I'm not sure why I'm getting this error message. Any ideas?

Thanks,

Jan