| Query created from reading in an Excel file - query | ||||
|---|---|---|---|---|
| CIGARSSMOKED | FIRSTNAME | LASTNAME | TOTALCOST | |
| 1 | cigarsSmoked | firstName | lastName | totalCost |
| 2 | 5 | Terrence | Ryan | 53 |
| 3 | 2 | Adam | Lehman | 17 |
| 4 | 3 | Ryan | Stewart | 29 |
| 5 | 1 | Kevin | Hoyt | 8 |
| 6 | 1 | Kevin | Hoyt | 8 |
| firstName | lastName | cigarsSmoked | totalCost |
|---|---|---|---|
| Terrence | Ryan | 5 | 53 |
| Adam | Lehman | 2 | 17 |
| Ryan | Stewart | 3 | 29 |