Hands On SQL

Page 6: Operators

Here's a query that finds all the drinks in easy_drinks that contain more than an ounce of soda (page 85). Write the additional queries on page 89.

We can find drinks that begin with an 'L' in drink_info like this. Try different letters or a range of letters and see what happens.

Finally, turn the two SELECTs below into a single SELECT statement using OR.


< Previous Page

Next Page >