Results of SELECT * FROM sample WHERE (sales <> 0) ORDER BY last_name ASC :
| id | last_name | first_name | sales |
|---|---|---|---|
| 6 | Andersen | David | 6420 |
| 29 | Berger | Sarah | 15000 |
| 28 | Berger | Aaron | 9000 |
| 3 | Buchanan | Steven | 3245 |
| 10 | Callahan | Laura | 3675 |
| 13 | Dodsworth | Nancy | 2750 |
| 7 | Edwards | Frank | 3840 |
| 1 | Fuller | Andrew | 5000 |
| 16 | Graham | Chris | 4050 |
| 15 | Hopkins | Peter | 6710 |
| 21 | Ingraham | Owen | 4750 |
| 9 | Jones | Edward | 3450 |
| 5 | King | Robert | 5290 |
| 30 | Lesica | John | 20000 |
| 2 | Leverling | Janet | 6250 |
| 11 | Miller | Greg | 5640 |
| 14 | Nelson | Beth | 4345 |
| 18 | Ostrander | Ian | 3965 |
| 4 | Peacock | Margaret | 4685 |
| 19 | Quinn | Howard | 5865 |
| 8 | Richards | Kate | 4260 |
| 20 | Smith | Fred | 6370 |
| 12 | Steel | Tammy | 3570 |
| 31 | Tan | Hector | 18500 |
| 17 | Thompson | Vincent | 4820 |
| 25 | Underwood | Debra | 3790 |
| 24 | Valentino | Linda | 2965 |
| 27 | White | Mark | 4500 |
| 32 | Witte | Bryan | 13100 |
| 26 | Xavier | Simon | 5580 |
| 22 | Youngs | Quincy | 4420 |
| 23 | Zimmerman | Walter | 4980 |