We're back on Yulp, and we're looking for restaurants that do delivery.
Recall the restaurants table.
| column_name | type |
|---|---|
id | INTEGER |
name | VARCHAR |
cuisine_type | VARCHAR |
delivery_fee_usd | NUMERIC |
address | VARCHAR |
Suppose the delivery_fee_usd column being non-null means that the restaurant does delivery.
Select all the restaurants that do delivery.
Try running a query…
| id INTEGER | name VARCHAR | cuisine_type VARCHAR | delivery_fee_usd NUMERIC | address VARCHAR | |
|---|---|---|---|---|---|
| 1 | 34037 | Harmonious Shift | NULL | 5 | 755 Crist Dam, Bolingbrook |
| 2 | 52951 | Outlying Centre | French | 6.5 | 09789 Deckow Ferry, Yakima |
| 3 | 38864 | Gently Accurate Homeownership | Taiwanese | 8 | 3102 Feest Walks, Kissimmee |
| 4 | 72451 | Knowing Geography | NULL | 9 | NULL |
| 5 | 50765 | Foolish Chapter | Greek | 3.5 | NULL |
| 6 | 23423 | Stale Spelt | Spanish | 7.5 | 1608 Pagac Path, Council Bluffs |
| 7 | 93737 | Diligently Grateful Pecan | Italian | 4.5 | NULL |
| 8 | 70336 | Worldly Menu | Vietnamese | 4 | 29098 Shany Overpass, Novato |
| 9 | 67230 | Scientific Standardization | NULL | 8 | 478 Arthur Port, Victoria |
| 10 | 28676 | Precious Art | NULL | 5 | NULL | 10 rows |