This is the "Fruit_sales" table used as the input table in this example.
date | orderid | itemid | cost | salesprice | |
---|---|---|---|---|---|
1 | 5/1/2010 | 100 | apples | 2.64 | 3.61 |
2 | 5/1/2010 | 100 | oranges | 1.32 | 1.46 |
3 | 5/1/2010 | 101 | grapes | 2.09 | 2.38 |
4 | 5/1/2010 | 101 | oranges | 1.02 | 1.45 |
5 | 5/1/2010 | 101 | apples | 1.33 | 1.65 |
6 | 5/1/2010 | 102 | grapes | 1.91 | 2.40 |
7 | 5/1/2010 | 102 | bananas | 2.45 | 3.29 |
8 | 5/1/2010 | 103 | kiwis | 1.99 | 2.33 |
9 | 5/1/2010 | 103 | grapes | 3.25 | 3.95 |
10 | 5/1/2010 | 103 | apples | 1.80 | 1.97 |
11 | 5/1/2010 | 103 | peaches | 1.15 | 1.47 |
12 | 5/1/2010 | 103 | plums | 3.20 | 3.84 |
13 | 5/2/2010 | 104 | apples | 1.87 | 3.21 |
14 | 5/2/2010 | 104 | grapes | 2.04 | 3.23 |
15 | 5/2/2010 | 105 | bananas | 2.78 | 2.82 |
16 | 5/2/2010 | 105 | kiwis | 2.96 | 4.35 |
17 | 5/2/2010 | 105 | peaches | 3.39 | 3.90 |
18 | 5/2/2010 | 105 | plums | 2.32 | 3.23 |
19 | 5/2/2010 | 105 | raspberries | 2.46 | 2.95 |
20 | 5/2/2010 | 105 | blueberries | 3.50 | 3.69 |
21 | 5/2/2010 | 105 | grapefruit | 3.66 | 4.40 |
22 | 5/3/2010 | 106 | bananas | 2.74 | 3.15 |
23 | 5/3/2010 | 106 | kiwis | 0.95 | 1.15 |
24 | 5/3/2010 | 106 | pears | 1.07 | 1.28 |
25 | 5/3/2010 | 107 | grapefruit | 0.76 | 1.26 |
26 | 5/3/2010 | 107 | tangerines | 0.87 | 1.19 |
27 | 5/3/2010 | 107 | oranges | 1.11 | 1.50 |
28 | 5/3/2010 | 107 | pears | 3.90 | 4.36 |
29 | 5/3/2010 | 107 | plums | 3.13 | 5.36 |
30 | 5/4/2010 | 108 | blueberries | 3.11 | 5.06 |
31 | 5/4/2010 | 108 | raspberries | 2.54 | 2.86 |
32 | 5/4/2010 | 108 | peras | 2.86 | 4.83 |
33 | 5/4/2010 | 108 | plums | 2.46 | 3.76 |
34 | 5/4/2010 | 109 | peaches | 2.66 | 2.73 |
35 | 5/4/2010 | 109 | plums | 1.22 | 1.33 |