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.
Steven Parker186,462 Points
The SELECTs and UNION are good, but to limit the results your queries will each need a WHERE clause.