Practice · Industry · Easy
Return the name, sector and founded_year of companies founded before 1950, oldest first.
Runs in your browser. No signup needed.
companies(name, sector, founded_year).
SELECT name, sector, founded_year
FROM companies
WHERE founded_year < 1950
ORDER BY founded_year;The reference solution is checked automatically when you run your query on the practice page — results are compared row by row, and order matters for this one.
Telecom Egypt traces to 1854 and the National Bank of Egypt to 1898 — some of Egypt’s biggest listed firms are over a century old. (company filings / Wikipedia)