Zach Shlenker1,526 Points
I need to exclude SQL query results that start with the letters L-Z.
What is the most efficient way to accomplish this without excluding each letter 1 by 1?
I tried several ways to do this, such as using:
WHERE Name BETWEEN 'A' AND 'K';
And this is the only way I could get it to pass:
SELECT Name FROM Fruit WHERE Name < 'L' UNION SELECT Name FROM Vegetable WHERE Name < 'L';
I hope that helps.
Stay safe and happy coding!