Using SQL data manipulation and joins to discover the oldest businesses around the world.
An important part of business is planning for the future and ensuring that the company survives changing market conditions. Some businesses do this really well and last for hundreds of years. In this project, we will explore data from BusinessFinancing.co.uk on the world's oldest businesses: when they were founded and which industries they belong to.
- Project Description
- The oldest business in the world
- How many businesses were founded before 1000?
- Which businesses were founded before 1000?
- Exploring the categories
- Counting the categories
- Oldest business by continent
- Joining everything for further analysis
- Counting categories by continent
- Filtering counts by continent and category