Original post: aus.social (Mastodon)

you are viewing a single comment's thread
view the rest of the comments
[–] 14 points 1 year ago (1 child)

"Whats this gap in your resume?"

"Syntax error"

  • source
  • parent
  • hideshow 2 child comments
  • [–] 7 points 1 year ago

    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%';`___`
    
  • source
  • parent