The Computer Store exercise 4

Back to The Computer Store

Select the name and price in cents (i.e., the price must be multiplied by 100).

| SELECT name, price FROM products
| CALC pricecents price 100 *
| PROJECT name, pricecents
10 rows 0 msec
name pricecents
Hard drive 24000
Memory 12000
ZIP drive 15000
Floppy disk 500
Monitor 24000
DVD drive 18000
CD drive 9000
Printer 27000
Toner cartridge 6600
DVD burner 18000


Use the CALC statement to make calculations within a tuple. The statement uses a RPN notation.