5 CREATE TABLE money_data (m money);
7 INSERT INTO money_data VALUES ('123');
8 SELECT * FROM money_data;
9 SELECT m + '123' FROM money_data;
10 SELECT m + '123.45' FROM money_data;
11 SELECT m - '123.45' FROM money_data;
12 SELECT m * 2 FROM money_data;
13 SELECT m / 2 FROM money_data;
16 SELECT m = '$123.00' FROM money_data;
17 SELECT m != '$124.00' FROM money_data;
18 SELECT m <= '$123.00' FROM money_data;
19 SELECT m >= '$123.00' FROM money_data;
20 SELECT m < '$124.00' FROM money_data;
21 SELECT m > '$122.00' FROM money_data;
24 SELECT m = '$123.01' FROM money_data;
25 SELECT m != '$123.00' FROM money_data;
26 SELECT m <= '$122.99' FROM money_data;
27 SELECT m >= '$123.01' FROM money_data;
28 SELECT m > '$124.00' FROM money_data;
29 SELECT m < '$122.00' FROM money_data;
31 SELECT cashlarger(m, '$124.00') FROM money_data;
32 SELECT cashsmaller(m, '$124.00') FROM money_data;
33 SELECT cash_words(m) FROM money_data;
34 SELECT cash_words(m + '1.23') FROM money_data;
36 DELETE FROM money_data;
37 INSERT INTO money_data VALUES ('$123.45');
38 SELECT * FROM money_data;
40 DELETE FROM money_data;
41 INSERT INTO money_data VALUES ('$123.451');
42 SELECT * FROM money_data;
44 DELETE FROM money_data;
45 INSERT INTO money_data VALUES ('$123.454');
46 SELECT * FROM money_data;
48 DELETE FROM money_data;
49 INSERT INTO money_data VALUES ('$123.455');
50 SELECT * FROM money_data;
52 DELETE FROM money_data;
53 INSERT INTO money_data VALUES ('$123.456');
54 SELECT * FROM money_data;
56 DELETE FROM money_data;
57 INSERT INTO money_data VALUES ('$123.459');
58 SELECT * FROM money_data;