Databases Querying Relational Databases Set Operations Set Operations

Limiting Results by First Letter of Name

Task 2 of the final assessment asks to limit the results of a Union by the first letter of the Fruit name, between A and K. I'm not sure if I'm just forgetting something I've already learned or not, but I'm stumped. I've got the UNION:

SELECT Name FROM Fruit UNION SELECT Name FROM Vegetable

From here, everything I've tried tells me that I'm not returning the correct data set.

1 Answer

Steven Parker
Steven Parker
186,462 Points

The SELECTs and UNION are good, but to limit the results your queries will each need a WHERE clause.