CREATE TABLE h1b (CASE_STATUS varchar(255), VISA_CLASS varchar(20), WORKSITE_STATE varchar(255), SOC_NAME varchar(255));
INSERT INTO h1b VALUES ('CERTIFIED-WITHDRAWN', 'H-1B', 'MI', 'BIOCHEMISTS AND BIOPHYSICISTS');
INSERT INTO h1b VALUES ('CERTIFIED', 'H-1B', 'CA', 'CHIEF EXECUTIVES');
INSERT INTO h1b VALUES ('WITHDRAWN', 'H-1B', 'CA', 'Computer Systems Analysts');
INSERT INTO h1b VALUES ('CERTIFIED', 'H-1B', 'CA', 'Software Developers');
INSERT INTO h1b VALUES ('CERTIFIED', 'H-4', 'MI', 'Software Developers');
INSERT INTO h1b VALUES ('CERTIFIED', 'H-1B', 'CA', 'Computer Systems Analysts');
INSERT INTO h1b VALUES ('CERTIFIED', 'H-1B', 'CA', 'Computer Systems Analysts');
INSERT INTO h1b VALUES ('CERTIFIED', 'H-1B', 'PA', 'Software Developers');
INSERT INTO h1b VALUES ('CERTIFIED', 'H-1B', 'CA', 'Computer Programmers');
INSERT INTO h1b VALUES ('CERTIFIED', 'H-1B', 'TA', 'Computer Systems Analysts');
INSERT INTO h1b VALUES ('CERTIFIED', 'H-1B', 'CA', 'Computer Programmers');
INSERT INTO h1b VALUES ('CERTIFIED', 'H-1B', 'CO', 'Accountants and Auditors');
INSERT INTO h1b VALUES ('CERTIFIED', 'H-1B', 'NY', 'Computer Programmers');
INSERT INTO h1b VALUES ('CERTIFIED', 'H-1B', 'NY', 'Electronics Engineers');
INSERT INTO h1b VALUES ('CERTIFIED', 'H-1B', 'FL', 'Software Developers');
INSERT INTO h1b VALUES ('CERTIFIED', 'H-1B', 'FL', 'Accountants and Auditors');
INSERT INTO h1b VALUES ('CERTIFIED', 'H-1B', 'WA', 'Software Developers');
INSERT INTO h1b VALUES ('CERTIFIED', 'H-1B', 'MA', 'Electronics Engineers');
INSERT INTO h1b VALUES ('CERTIFIED', 'H-1B', 'TA', 'Accountants and Auditors');
INSERT INTO h1b VALUES ('CERTIFIED', 'H-1B', 'IL', 'Software Developers');
INSERT INTO h1b VALUES ('CERTIFIED', 'H-1B', 'IL', 'Accountants and Auditors');
INSERT INTO h1b VALUES ('CERTIFIED', 'H-1B', 'PA', 'Electronics Engineers');
INSERT INTO h1b VALUES ('CERTIFIED', 'H-1B', 'PA', 'Accountants and Auditors');
INSERT INTO h1b VALUES ('CERTIFIED', 'H-1B', 'MA', 'Computer Programmers');
INSERT INTO h1b VALUES ('CERTIFIED', 'H-1B', 'MA', 'Operations Research Analysts');
INSERT INTO h1b VALUES ('CERTIFIED', 'H-1B', 'GA', 'Accountants and Auditors');
INSERT INTO h1b VALUES ('CERTIFIED', 'H-1B', 'GA', 'Operations Research Analysts');
INSERT INTO h1b VALUES ('CERTIFIED', 'H-1B', 'GA', 'Operations Research Analysts');
INSERT INTO h1b VALUES ('CERTIFIED', 'H-1B', 'CA', 'Accountants and Auditors');
INSERT INTO h1b VALUES ('CERTIFIED', 'H-1B', 'PA', 'Accountants and Auditors');
INSERT INTO h1b VALUES ('CERTIFIED', 'H-1B', 'WA', 'Management Analysts');
INSERT INTO h1b VALUES ('CERTIFIED', 'H-1B', 'IL', 'Management Analysts');
INSERT INTO h1b VALUES ('CERTIFIED', 'H-1B', 'PA', 'Management Analysts');
INSERT INTO h1b VALUES ('CERTIFIED', 'H-1B', 'NY', 'Accountants and Auditors');
INSERT INTO h1b VALUES ('CERTIFIED', 'H-1B', 'NY', 'Financial Analysts');
INSERT INTO h1b VALUES ('CERTIFIED', 'H-1B', 'TA', 'Financial Analysts');