Stacy Villibord2,017 Points
Task 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!
What I coded. Not sure what is wrong.
SELECT Name FROM Fruit UNION ALL SELECT Name FROM Vegetable ORDER BY Name DESC:
Steven Parker201,320 Points
You're really close, but:
- the challenge is not expecting the list to be in in reverse (descending) order
- the query should optionally end with a semicolon (;), but not a colon (:)