• 13igTyme@lemmy.world
      link
      fedilink
      English
      arrow-up
      7
      ·
      7 days 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%';`___`