Databases Querying Relational Databases Set Operations Set Operations

Stacy Villibord
Stacy Villibord
2,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:

1 Answer

Steven Parker
Steven Parker
201,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 (:)