-- Standard SQL-92

-- Populate Restricted

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 '9999-12-31')

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

SELECT * FROM LOT