CREATE TABLE plates (WELL_CODE VARCHAR NOT NULL, MATERIAL_CODE VARCHAR NOT NULL, ABASE_COMPOUND_ID VARCHAR NOT NULL, ABASE_PLATE_CODE VARCHAR NOT NULL);
INSERT  INTO plates (well_code, material_code, abase_compound_id, abase_plate_code) values ('A001', 'COMPOUND-BATCH-1', 'COMPOUND-1', 'PLATE1');
INSERT  INTO plates (well_code, material_code, abase_compound_id, abase_plate_code) values ('A002', 'COMPOUND-BATCH-2', 'COMPOUND-2', 'PLATE1');
INSERT  INTO plates (well_code, material_code, abase_compound_id, abase_plate_code) values ('A003', 'COMPOUND-BATCH-3', 'COMPOUND-3', 'PLATE1');
INSERT  INTO plates (well_code, material_code, abase_compound_id, abase_plate_code) values ('A004', 'COMPOUND-BATCH-4', 'COMPOUND-4', 'PLATE1');
INSERT  INTO plates (well_code, material_code, abase_compound_id, abase_plate_code) values ('A005', 'COMPOUND-BATCH-5', 'COMPOUND-5', 'PLATE1');
INSERT  INTO plates (well_code, material_code, abase_compound_id, abase_plate_code) values ('A006', 'COMPOUND-BATCH-6', 'COMPOUND-6', 'PLATE1');
INSERT  INTO plates (well_code, material_code, abase_compound_id, abase_plate_code) values ('A007', 'COMPOUND-BATCH-7', 'COMPOUND-7', 'PLATE1');
INSERT  INTO plates (well_code, material_code, abase_compound_id, abase_plate_code) values ('A008', 'COMPOUND-BATCH-8', 'COMPOUND-8', 'PLATE1');
INSERT  INTO plates (well_code, material_code, abase_compound_id, abase_plate_code) values ('A009', 'COMPOUND-BATCH-9', 'COMPOUND-9', 'PLATE1');
INSERT  INTO plates (well_code, material_code, abase_compound_id, abase_plate_code) values ('A010', 'COMPOUND-BATCH-10', 'COMPOUND-10', 'PLATE1');
INSERT  INTO plates (well_code, material_code, abase_compound_id, abase_plate_code) values ('A011', 'COMPOUND-BATCH-11', 'COMPOUND-11', 'PLATE1');
INSERT  INTO plates (well_code, material_code, abase_compound_id, abase_plate_code) values ('A012', 'COMPOUND-BATCH-12', 'COMPOUND-12', 'PLATE1');
INSERT  INTO plates (well_code, material_code, abase_compound_id, abase_plate_code) values ('A013', 'COMPOUND-BATCH-13', 'COMPOUND-13', 'PLATE1');
INSERT  INTO plates (well_code, material_code, abase_compound_id, abase_plate_code) values ('A014', 'COMPOUND-BATCH-14', 'COMPOUND-14', 'PLATE1');
INSERT  INTO plates (well_code, material_code, abase_compound_id, abase_plate_code) values ('A015', 'COMPOUND-BATCH-15', 'COMPOUND-15', 'PLATE1');
INSERT  INTO plates (well_code, material_code, abase_compound_id, abase_plate_code) values ('A016', 'COMPOUND-BATCH-16', 'COMPOUND-16', 'PLATE1');
INSERT  INTO plates (well_code, material_code, abase_compound_id, abase_plate_code) values ('A017', 'COMPOUND-BATCH-17', 'COMPOUND-17', 'PLATE1');
INSERT  INTO plates (well_code, material_code, abase_compound_id, abase_plate_code) values ('A018', 'COMPOUND-BATCH-18', 'COMPOUND-18', 'PLATE1');
INSERT  INTO plates (well_code, material_code, abase_compound_id, abase_plate_code) values ('A019', 'COMPOUND-BATCH-19', 'COMPOUND-19', 'PLATE1');
INSERT  INTO plates (well_code, material_code, abase_compound_id, abase_plate_code) values ('A020', 'COMPOUND-BATCH-20', 'COMPOUND-20', 'PLATE1');
INSERT  INTO plates (well_code, material_code, abase_compound_id, abase_plate_code) values ('A021', 'COMPOUND-BATCH-21', 'COMPOUND-21', 'PLATE1');
INSERT  INTO plates (well_code, material_code, abase_compound_id, abase_plate_code) values ('A022', 'COMPOUND-BATCH-22', 'COMPOUND-22', 'PLATE1');
INSERT  INTO plates (well_code, material_code, abase_compound_id, abase_plate_code) values ('A023', 'COMPOUND-BATCH-23', 'COMPOUND-23', 'PLATE1');
INSERT  INTO plates (well_code, material_code, abase_compound_id, abase_plate_code) values ('A024', 'COMPOUND-BATCH-24', 'COMPOUND-24', 'PLATE1');

INSERT  INTO plates (well_code, material_code, abase_compound_id, abase_plate_code) values ('P001', 'COMPOUND-BATCH-1', 'COMPOUND-1', 'PLATE1');
INSERT  INTO plates (well_code, material_code, abase_compound_id, abase_plate_code) values ('P002', 'COMPOUND-BATCH-2', 'COMPOUND-2', 'PLATE1');
INSERT  INTO plates (well_code, material_code, abase_compound_id, abase_plate_code) values ('P003', 'COMPOUND-BATCH-3', 'COMPOUND-3', 'PLATE1');
INSERT  INTO plates (well_code, material_code, abase_compound_id, abase_plate_code) values ('P004', 'COMPOUND-BATCH-4', 'COMPOUND-4', 'PLATE1');
INSERT  INTO plates (well_code, material_code, abase_compound_id, abase_plate_code) values ('P005', 'COMPOUND-BATCH-5', 'COMPOUND-5', 'PLATE1');
INSERT  INTO plates (well_code, material_code, abase_compound_id, abase_plate_code) values ('P006', 'COMPOUND-BATCH-6', 'COMPOUND-6', 'PLATE1');
INSERT  INTO plates (well_code, material_code, abase_compound_id, abase_plate_code) values ('P007', 'COMPOUND-BATCH-7', 'COMPOUND-7', 'PLATE1');
INSERT  INTO plates (well_code, material_code, abase_compound_id, abase_plate_code) values ('P008', 'COMPOUND-BATCH-8', 'COMPOUND-8', 'PLATE1');
INSERT  INTO plates (well_code, material_code, abase_compound_id, abase_plate_code) values ('P009', 'COMPOUND-BATCH-9', 'COMPOUND-9', 'PLATE1');
INSERT  INTO plates (well_code, material_code, abase_compound_id, abase_plate_code) values ('P010', 'COMPOUND-BATCH-10', 'COMPOUND-10', 'PLATE1');
INSERT  INTO plates (well_code, material_code, abase_compound_id, abase_plate_code) values ('P011', 'COMPOUND-BATCH-11', 'COMPOUND-11', 'PLATE1');
INSERT  INTO plates (well_code, material_code, abase_compound_id, abase_plate_code) values ('P012', 'COMPOUND-BATCH-12', 'COMPOUND-12', 'PLATE1');
INSERT  INTO plates (well_code, material_code, abase_compound_id, abase_plate_code) values ('P013', 'COMPOUND-BATCH-13', 'COMPOUND-13', 'PLATE1');
INSERT  INTO plates (well_code, material_code, abase_compound_id, abase_plate_code) values ('P014', 'COMPOUND-BATCH-14', 'COMPOUND-14', 'PLATE1');
INSERT  INTO plates (well_code, material_code, abase_compound_id, abase_plate_code) values ('P015', 'COMPOUND-BATCH-15', 'COMPOUND-15', 'PLATE1');
INSERT  INTO plates (well_code, material_code, abase_compound_id, abase_plate_code) values ('P016', 'COMPOUND-BATCH-16', 'COMPOUND-16', 'PLATE1');
INSERT  INTO plates (well_code, material_code, abase_compound_id, abase_plate_code) values ('P017', 'COMPOUND-BATCH-17', 'COMPOUND-17', 'PLATE1');
INSERT  INTO plates (well_code, material_code, abase_compound_id, abase_plate_code) values ('P018', 'COMPOUND-BATCH-18', 'COMPOUND-18', 'PLATE1');
INSERT  INTO plates (well_code, material_code, abase_compound_id, abase_plate_code) values ('P019', 'COMPOUND-BATCH-19', 'COMPOUND-19', 'PLATE1');
INSERT  INTO plates (well_code, material_code, abase_compound_id, abase_plate_code) values ('P020', 'COMPOUND-BATCH-20', 'COMPOUND-20', 'PLATE1');
INSERT  INTO plates (well_code, material_code, abase_compound_id, abase_plate_code) values ('P021', 'COMPOUND-BATCH-21', 'COMPOUND-21', 'PLATE1');
INSERT  INTO plates (well_code, material_code, abase_compound_id, abase_plate_code) values ('P022', 'COMPOUND-BATCH-22', 'COMPOUND-22', 'PLATE1');
INSERT  INTO plates (well_code, material_code, abase_compound_id, abase_plate_code) values ('P023', 'COMPOUND-BATCH-23', 'COMPOUND-23', 'PLATE1');
INSERT  INTO plates (well_code, material_code, abase_compound_id, abase_plate_code) values ('P024', 'COMPOUND-BATCH-24', 'COMPOUND-24', 'PLATE1');