SQL Statement

profilehadeln
item_table.xlsx

Sheet1

ItemID ItemDescription PurchaseDate ItemCost ItemPrice VendorID
1 Antique Desk 11/7/13 $1,800.00 $3,000.00 2
2 Antique Desk Chair 11/10/13 $300.00 $500.00 4
3 Dining Table Linens 11/14/13 $600.00 $1,000.00 1
4 Candles 11/14/13 $30.00 $50.00 1
5 Candles 11/14/13 $27.00 $45.00 1
6 Desk Lamp 11/14/13 $150.00 $250.00 3
7 Dining Table Linens 11/14/13 $450.00 $750.00 1
8 Book Shelf 11/21/13 $150.00 $250.00 5
9 Antique Chair 11/21/13 $750.00 $1,250.00 6
10 Antique Chair 11/21/13 $1,050.00 $1,750.00 6
11 Antique Candle Holders 11/28/13 $210.00 $350.00 2
12 Antique Desk 1/5/14 $1,920.00 $3,200.00 2
13 Antique Desk 1/5/14 $2,100.00 $3,500.00 2
14 Antique Desk Chair 1/6/14 $285.00 $475.00 9
15 Antique Desk Chair 1/6/14 $339.00 $565.00 9
16 Desk Lamp 1/6/14 $150.00 $250.00 10
17 Desk Lamp 1/6/14 $150.00 $250.00 10
18 Desk Lamp 1/6/14 $144.00 $240.00 3
19 Antique Dining Table 1/10/14 $3,000 $5,000.00 7
20 Antique Sideboard 1/11/14 $2,700.00 $4,500.00 8
21 Dining Table Chairs 1/11/14 $5,100.00 $8,500.00 9
22 Dining Table Chairs 1/12/14 $450.00 $750.00 1
23 Dining Table Chairs 1/12/14 $480.00 $800.00 1
24 Candles 1/17/14 $30.00 $50.00 1
25 Candles 1/17/14 $36.00 $60.00 1