linkedin_employment_timeline

Column Type
company_name TEXT
job_title TEXT
start_date TEXT
end_date TEXT

SQL DDL

CREATE VIEW linkedin_employment_timeline AS
SELECT 
    p."Company Name" AS company_name,
    p."Title" AS job_title,
    p."Started On" AS start_date,
    p."Finished On" AS end_date
FROM uniform_resource_positions p
ORDER BY start_date DESC