Produce a new extract from all the data in the stationary table that:
Contains a new field called Profit which is calculated at run time. This field will subtract the purchase price from the sale price
Contains a new field called Percent to calculate the percentage profit for each car at run time. This field will divide the profit by the sale price
Contains a new field called UnitProfit. This field will divide the profit by the quantity.
For each calculated field show how you performed the calculation and the results of the calculation Save the database using your last name_first name_CT6 and take a screen shot to show performed task.
Sun | Mon | Tue | Wed | Thu | Fri | Sat |
---|---|---|---|---|---|---|
23 | 24 | 25 | 26 | 27 | 28 | 1 |
2 | 3 | 4 | 5 | 6 | 7 | 8 |
9 | 10 | 11 | 12 | 13 | 14 | 15 |
16 | 17 | 18 | 19 | 20 | 21 | 22 |
23 | 24 | 25 | 26 | 27 | 28 | 29 |
30 | 31 | 1 | 2 | 3 | 4 | 5 |
Get Free Quote!
409 Experts Online