Analyzing unicorn company data

SELECT table_name
FROM information_schema.tables
WHERE table_schema = 'public'
ORDER BY table_name;

SELECT table_name
FROM information_schema.tables
WHERE table_schema = 'pg_catalog'
AND table_name LIKE 'pg_%'
ORDER BY table_name;

SELECT table_name
FROM information_schema.tables
WHERE table_schema = 'public'
AND table_name LIKE '%unicorn%';

SELECT * FROM companies;

SELECT c.company, f.funding, f.valuation
FROM companies c
JOIN funding f ON c.company_id = f.company_id;