CREATE TABLE interests_illus_occupations (
  element_id CHARACTER VARYING(20) NOT NULL,
  interest_type CHARACTER VARYING(20) NOT NULL,
  onetsoc_code CHARACTER(10) NOT NULL,
  FOREIGN KEY (element_id) REFERENCES content_model_reference(element_id),
  FOREIGN KEY (onetsoc_code) REFERENCES occupation_data(onetsoc_code));
GO

INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.1.a', 'General', '17-3024.01');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.1.a', 'General', '45-2091.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.1.a', 'General', '47-2031.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.1.a', 'General', '53-3052.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.1.b', 'General', '19-1029.04');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.1.b', 'General', '19-1042.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.1.b', 'General', '19-2031.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.1.b', 'General', '19-3041.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.1.c', 'General', '27-1012.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.1.c', 'General', '27-1013.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.1.c', 'General', '27-2011.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.1.c', 'General', '27-2042.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.1.d', 'General', '21-1012.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.1.d', 'General', '21-1021.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.1.d', 'General', '25-2021.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.1.d', 'General', '29-1141.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.1.e', 'General', '11-2011.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.1.e', 'General', '13-1161.01');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.1.e', 'General', '23-1011.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.1.e', 'General', '41-2031.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.1.f', 'General', '13-1041.01');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.1.f', 'General', '13-2061.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.1.f', 'General', '15-1242.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.1.f', 'General', '43-9061.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.a', 'Basic', '17-3024.01');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.a', 'Basic', '49-2092.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.a', 'Basic', '49-2094.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.a', 'Basic', '49-3011.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.a', 'Basic', '49-9081.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.b', 'Basic', '47-2031.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.b', 'Basic', '51-7011.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.b', 'Basic', '51-7021.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.b', 'Basic', '51-7031.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.b', 'Basic', '51-7042.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.c', 'Basic', '53-3032.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.c', 'Basic', '53-3052.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.c', 'Basic', '53-3054.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.c', 'Basic', '53-4011.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.c', 'Basic', '53-7051.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.d', 'Basic', '45-2041.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.d', 'Basic', '47-2061.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.d', 'Basic', '47-5081.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.d', 'Basic', '53-7062.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.e', 'Basic', '33-3021.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.e', 'Basic', '33-3051.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.e', 'Basic', '33-3051.04');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.e', 'Basic', '33-9032.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.f', 'Basic', '11-9013.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.f', 'Basic', '19-1031.02');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.f', 'Basic', '45-1011.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.f', 'Basic', '45-2092.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.g', 'Basic', '19-1032.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.g', 'Basic', '19-2041.02');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.g', 'Basic', '19-4071.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.g', 'Basic', '37-3011.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.h', 'Basic', '29-1131.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.h', 'Basic', '33-9011.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.h', 'Basic', '39-2011.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.h', 'Basic', '39-2021.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.i', 'Basic', '11-9179.01');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.i', 'Basic', '27-2021.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.i', 'Basic', '27-2022.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.i', 'Basic', '27-2023.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.i', 'Basic', '29-9091.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.j', 'Basic', '17-2011.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.j', 'Basic', '17-2051.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.j', 'Basic', '17-2141.02');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.j', 'Basic', '17-2199.11');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.j', 'Basic', '17-3023.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.j', 'Basic', '17-3027.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.k', 'Basic', '19-1013.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.k', 'Basic', '19-2011.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.k', 'Basic', '19-2012.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.k', 'Basic', '19-2021.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.k', 'Basic', '19-2031.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.l', 'Basic', '19-1022.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.l', 'Basic', '19-1023.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.l', 'Basic', '19-1029.03');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.l', 'Basic', '19-1029.04');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.m', 'Basic', '17-2031.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.m', 'Basic', '19-1029.02');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.m', 'Basic', '19-1041.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.m', 'Basic', '19-1042.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.n', 'Basic', '19-3011.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.n', 'Basic', '19-3033.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.n', 'Basic', '19-3041.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.n', 'Basic', '19-3094.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.o', 'Basic', '19-3091.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.o', 'Basic', '19-3093.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.o', 'Basic', '25-1062.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.o', 'Basic', '25-1123.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.p', 'Basic', '15-2021.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.p', 'Basic', '15-2041.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.p', 'Basic', '15-2041.01');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.p', 'Basic', '15-2051.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.q', 'Basic', '15-1212.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.q', 'Basic', '15-1242.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.q', 'Basic', '15-1251.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.r', 'Basic', '27-1011.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.r', 'Basic', '27-1013.00');
GO
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.r', 'Basic', '27-1014.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.r', 'Basic', '27-1024.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.r', 'Basic', '27-4021.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.r', 'Basic', '27-4032.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.s', 'Basic', '27-1012.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.s', 'Basic', '27-1021.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.s', 'Basic', '27-1025.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.s', 'Basic', '27-1027.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.t', 'Basic', '27-2011.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.t', 'Basic', '27-2031.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.t', 'Basic', '27-2032.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.u', 'Basic', '27-2041.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.u', 'Basic', '27-2042.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.v', 'Basic', '15-1255.01');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.v', 'Basic', '27-3041.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.v', 'Basic', '27-3043.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.v', 'Basic', '27-3043.05');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.w', 'Basic', '27-2012.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.w', 'Basic', '27-3011.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.w', 'Basic', '27-3023.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.x', 'Basic', '35-1011.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.x', 'Basic', '35-2013.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.x', 'Basic', '35-2014.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.x', 'Basic', '51-3011.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.y', 'Basic', '25-2011.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.y', 'Basic', '25-2012.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.y', 'Basic', '25-2021.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.y', 'Basic', '25-2022.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.y', 'Basic', '25-2031.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.z', 'Basic', '21-1013.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.z', 'Basic', '21-1014.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.z', 'Basic', '21-1021.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.z', 'Basic', '21-1094.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.z', 'Basic', '31-1122.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.aa', 'Basic', '29-1021.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.aa', 'Basic', '29-1141.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.aa', 'Basic', '29-1215.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.aa', 'Basic', '29-2043.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.aa', 'Basic', '31-9092.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.ab', 'Basic', '21-2011.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.ab', 'Basic', '21-2021.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.ab', 'Basic', '25-1126.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.ac', 'Basic', '39-6012.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.ac', 'Basic', '39-7011.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.ac', 'Basic', '41-3041.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.ad', 'Basic', '13-1011.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.ad', 'Basic', '13-1151.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.ad', 'Basic', '21-1012.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.ae', 'Basic', '11-1011.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.ae', 'Basic', '13-1022.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.ae', 'Basic', '13-1161.01');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.af', 'Basic', '41-2031.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.af', 'Basic', '41-3031.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.af', 'Basic', '41-4012.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.af', 'Basic', '41-9091.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.ag', 'Basic', '11-2011.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.ag', 'Basic', '11-2021.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.ag', 'Basic', '13-1161.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.ag', 'Basic', '27-3031.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.ah', 'Basic', '11-3031.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.ah', 'Basic', '11-3031.01');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.ah', 'Basic', '13-2051.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.ah', 'Basic', '13-2052.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.ah', 'Basic', '13-2061.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.ai', 'Basic', '13-2011.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.ai', 'Basic', '43-3021.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.ai', 'Basic', '43-3031.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.ai', 'Basic', '43-3051.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.aj', 'Basic', '11-3121.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.aj', 'Basic', '13-1071.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.aj', 'Basic', '13-1141.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.aj', 'Basic', '43-4161.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.ak', 'Basic', '43-4071.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.ak', 'Basic', '43-5051.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.ak', 'Basic', '43-6014.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.ak', 'Basic', '43-9061.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.al', 'Basic', '11-1021.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.al', 'Basic', '11-3012.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.al', 'Basic', '11-9111.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.am', 'Basic', '13-1131.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.am', 'Basic', '25-1122.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.an', 'Basic', '11-1031.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.ao', 'Basic', '23-1011.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.ao', 'Basic', '23-1021.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.ao', 'Basic', '23-1023.00');
INSERT INTO interests_illus_occupations (element_id, interest_type, onetsoc_code) VALUES ('1.B.3.ao', 'Basic', '23-2011.00');
GO

