mysql>
mysql>
mysql> CREATE TABLE COMMITTEE_MEMBERS
-> (EmployeeNO INTEGER NOT NULL,
-> BEGIN_DATE DATE NOT NULL,
-> END_DATE DATE ,
-> POSITION CHAR(20) ,
-> PRIMARY KEY (EmployeeNO, BEGIN_DATE));
Query OK, 0 rows affected (0.00 sec)
mysql>
mysql> INSERT INTO COMMITTEE_MEMBERS VALUES ( 6, '1990-01-01', '1990-12-31', 'Secretary');
Query OK, 1 row affected (0.00 sec)
mysql> INSERT INTO COMMITTEE_MEMBERS VALUES ( 6, '1991-01-01', '1992-12-31', 'Member');
Query OK, 1 row affected (0.00 sec)
mysql> INSERT INTO COMMITTEE_MEMBERS VALUES ( 6, '1992-01-01', '1993-12-31', 'Treasurer');
Query OK, 1 row affected (0.00 sec)
mysql> INSERT INTO COMMITTEE_MEMBERS VALUES ( 6, '1993-01-01', NULL, 'Chairman');
Query OK, 1 row affected (0.00 sec)
mysql> INSERT INTO COMMITTEE_MEMBERS VALUES ( 2, '1990-01-01', '1992-12-31', 'Chairman');
Query OK, 1 row affected (0.00 sec)
mysql> INSERT INTO COMMITTEE_MEMBERS VALUES ( 2, '1994-01-01', NULL, 'Member');
Query OK, 1 row affected (0.00 sec)
mysql> INSERT INTO COMMITTEE_MEMBERS VALUES (112, '1992-01-01', '1992-12-31', 'Member');
Query OK, 1 row affected (0.00 sec)
mysql> INSERT INTO COMMITTEE_MEMBERS VALUES (112, '1994-01-01', NULL, 'Secretary');
Query OK, 1 row affected (0.00 sec)
mysql> INSERT INTO COMMITTEE_MEMBERS VALUES ( 8, '1990-01-01', '1990-12-31', 'Treasurer');
Query OK, 1 row affected (0.00 sec)
mysql> INSERT INTO COMMITTEE_MEMBERS VALUES ( 8, '1991-01-01', '1991-12-31', 'Secretary');
Query OK, 1 row affected (0.00 sec)
mysql> INSERT INTO COMMITTEE_MEMBERS VALUES ( 8, '1993-01-01', '1993-12-31', 'Member');
Query OK, 1 row affected (0.00 sec)
mysql> INSERT INTO COMMITTEE_MEMBERS VALUES ( 8, '1994-01-01', NULL, 'Member');
Query OK, 1 row affected (0.00 sec)
mysql> INSERT INTO COMMITTEE_MEMBERS VALUES ( 57, '1992-01-01', '1992-12-31', 'Secretary');
Query OK, 1 row affected (0.00 sec)
mysql> INSERT INTO COMMITTEE_MEMBERS VALUES ( 27, '1990-01-01', '1990-12-31', 'Member');
Query OK, 1 row affected (0.00 sec)
mysql> INSERT INTO COMMITTEE_MEMBERS VALUES ( 27, '1991-01-01', '1991-12-31', 'Treasurer');
Query OK, 1 row affected (0.00 sec)
mysql> INSERT INTO COMMITTEE_MEMBERS VALUES ( 27, '1993-01-01', '1993-12-31', 'Treasurer');
Query OK, 1 row affected (0.00 sec)
mysql> INSERT INTO COMMITTEE_MEMBERS VALUES ( 95, '1994-01-01', NULL, 'Treasurer');
Query OK, 1 row affected (0.00 sec)
mysql>
mysql>
mysql> SELECT EmployeeNO, BEGIN_DATE,
-> BEGIN_DATE + INTERVAL 2 MONTH + INTERVAL 3 DAY
-> FROM COMMITTEE_MEMBERS;
+------------+------------+------------------------------------------------+
| EmployeeNO | BEGIN_DATE | BEGIN_DATE + INTERVAL 2 MONTH + INTERVAL 3 DAY |
+------------+------------+------------------------------------------------+
| 2 | 1990-01-01 | 1990-03-04 |
| 2 | 1994-01-01 | 1994-03-04 |
| 6 | 1990-01-01 | 1990-03-04 |
| 6 | 1991-01-01 | 1991-03-04 |
| 6 | 1992-01-01 | 1992-03-04 |
| 6 | 1993-01-01 | 1993-03-04 |
| 8 | 1990-01-01 | 1990-03-04 |
| 8 | 1991-01-01 | 1991-03-04 |
| 8 | 1993-01-01 | 1993-03-04 |
| 8 | 1994-01-01 | 1994-03-04 |
| 27 | 1990-01-01 | 1990-03-04 |
| 27 | 1991-01-01 | 1991-03-04 |
| 27 | 1993-01-01 | 1993-03-04 |
| 57 | 1992-01-01 | 1992-03-04 |
| 95 | 1994-01-01 | 1994-03-04 |
| 112 | 1992-01-01 | 1992-03-04 |
| 112 | 1994-01-01 | 1994-03-04 |
+------------+------------+------------------------------------------------+
17 rows in set (0.00 sec)
mysql>
mysql> drop table COMMITTEE_MEMBERS;
Query OK, 0 rows affected (0.00 sec)
mysql>