-- standard SQL-92

-- Populate General

DROP TABLE LOT

CREATE TABLE LOT(LOT_ID_NUM INT, GNDR_CODE CHAR(1), FROM_DATE DATE, TO_DATE DATE)

INSERT INTO LOT(LOT_ID_NUM, GNDR_CODE, FROM_DATE, TO_DATE)
VALUES (101, 'c', DATE '1998-01-01', DATE '1998-03-23')

INSERT INTO LOT(LOT_ID_NUM, GNDR_CODE, FROM_DATE, TO_DATE)
VALUES (101, 's', DATE '1998-03-23', DATE '9999-12-31')

INSERT INTO LOT(LOT_ID_NUM, GNDR_CODE, FROM_DATE, TO_DATE)
VALUES (234, 'c', DATE '1998-02-17', DATE '1998-03-22')

INSERT INTO LOT(LOT_ID_NUM, GNDR_CODE, FROM_DATE, TO_DATE)
VALUES (234, 'c', DATE '1998-03-22', DATE '1998-04-01')

INSERT INTO LOT(LOT_ID_NUM, GNDR_CODE, FROM_DATE, TO_DATE)
VALUES (234, 'c', DATE '1998-04-01', DATE '1998-05-10')

INSERT INTO LOT(LOT_ID_NUM, GNDR_CODE, FROM_DATE, TO_DATE)
VALUES (234, 'c', DATE '1998-05-10', DATE '1998-06-29')

INSERT INTO LOT(LOT_ID_NUM, GNDR_CODE, FROM_DATE, TO_DATE)
VALUES (234, 'c', DATE '1998-06-29', DATE '1998-10-17')

INSERT INTO LOT(LOT_ID_NUM, GNDR_CODE, FROM_DATE, TO_DATE)
VALUES (234, 'c', DATE '1998-10-17', DATE '1998-10-19')

INSERT INTO LOT(LOT_ID_NUM, GNDR_CODE, FROM_DATE, TO_DATE)
VALUES (234, 'c', DATE '1998-10-19', DATE '9999-12-31')

INSERT INTO LOT(LOT_ID_NUM, GNDR_CODE, FROM_DATE, TO_DATE)
VALUES (799, 'c', DATE '1998-02-27', DATE '1998-03-12')

INSERT INTO LOT(LOT_ID_NUM, GNDR_CODE, FROM_DATE, TO_DATE)
VALUES (799, 'c', DATE '1998-03-12', DATE '1998-04-09')

INSERT INTO LOT(LOT_ID_NUM, GNDR_CODE, FROM_DATE, TO_DATE)
VALUES (799, 'c', DATE '1998-04-09', DATE '1998-05-21')

INSERT INTO LOT(LOT_ID_NUM, GNDR_CODE, FROM_DATE, TO_DATE)
VALUES (799, 'c', DATE '1998-05-21', DATE '1998-09-13')

INSERT INTO LOT(LOT_ID_NUM, GNDR_CODE, FROM_DATE, TO_DATE)
VALUES (799, 'c', DATE '1998-09-13', DATE '9999-12-31')

SELECT * FROM LOT