SELECT 
    job_id,
    job_title_short,
    salary_year_avg,
    company_id
FROM 
    job_postings_fact
LIMIT 10;

SELECT 
    company_id,
    name
FROM
    company_dim 
LIMIT 100;

SELECT *
FROM information_schema.tables
WHERE 
    table_catalog='data_jobs';

SELECT *
FROM information_schema.columns
WHERE 
    table_catalog='data_jobs';


SELECT * 
FROM information_schema.table_constraints
WHERE 
    table_catalog= 'data_jobs' 
AND
    constraint_type IN ('PRIMARY KEY', 'FOREIGN KEY');

SELECT * 
FROM information_schema.key_column_usage
WHERE 
    table_catalog= 'data_jobs'; 

PRAGMA show_tables_expanded;

DESCRIBE job_postings_fact;