CREATETABLE Resume (
Field VARCHAR(255) PRIMARY KEY,
ValueVARCHAR(255)
);
INSERTINTO Resume (Field, Value) VALUES
('Experience_1_Title', ''),
('Experience_1_Company', ''),
('Experience_1_Years', ''),
('Experience_1_Description', '.'),
('Experience_2_Title', ''),
('Experience_2_Company', ''),
('Experience_2_Years', ''),
('Experience_2_Description', '.'),
('Skills_1', ''),
('Skills_2', ''),
('Skills_3', ''),
('Skills_4', ''),
('Education_Degree', ''),
('Education_Years', '),
('References', '');
SELECT Field, Value FROM Resume;
-- Bonus Query: Show my most "impressive" skill
SELECT Value FROM Resume WHERE Field = 'Skills_1';
-- Another Bonus: My career trajectory
SELECT Field, Value FROM Resume WHERE Field LIKE 'Experience%';`___`
Resumes in JSON when?
“Whats this gap in your resume?”
“Syntax error”
I see for past experience you put :
CREATE TABLE Resume ( Field VARCHAR(255) PRIMARY KEY, Value VARCHAR(255) ); INSERT INTO Resume (Field, Value) VALUES ('Experience_1_Title', ''), ('Experience_1_Company', ''), ('Experience_1_Years', ''), ('Experience_1_Description', '.'), ('Experience_2_Title', ''), ('Experience_2_Company', ''), ('Experience_2_Years', ''), ('Experience_2_Description', '.'), ('Skills_1', ''), ('Skills_2', ''), ('Skills_3', ''), ('Skills_4', ''), ('Education_Degree', ''), ('Education_Years', '), ('References', ''); SELECT Field, Value FROM Resume; -- Bonus Query: Show my most "impressive" skill SELECT Value FROM Resume WHERE Field = 'Skills_1'; -- Another Bonus: My career trajectory SELECT Field, Value FROM Resume WHERE Field LIKE 'Experience%';`___`