Strata Scratch Problem Sets

Problem sets, exercises, and educational guides for SQL and python. These exercises are specifically tailored for business and marketing analytics students and novices.

Back to the Strata Scratch website
Login to Strata Scratch

Forbes Global Exercises

The Forbes Global 2000 is an annual ranking of the top 2,000 public companies in the world by Forbes magazine. The ranking is based on a mix of four metrics: sales, profit, assets and market value. The list has been published since 2003. Our dataset consists of 2000 rows and 10 columns. The columns are rank, company, country, continent, sector, industry, market value, sales, profits, and assets. The purpose of this dataset is to help you figure out what kind of industries are currently the most profitable and popular, as well as the top countries that are currently having these companies.

The table used for the following exercises can be found at datasets.forbes_global_2010_2014.

Question 1

Which country has the most companies from the dataset?

Question 2

Which is the most popular sector from the list?

Question 3

Which industries boast the highest number of companies?

Question 4

What is the average profit for the major banks industry?

Question 5

Which industry has the highest market value in Asia?

Question 6

What is the total market value of the financial sector?

Question 7

How many American companies are on the list?

Question 8

What are the top 3 sectors in the United States by the average rank?

Question 9

What are the total assets of the energy sector?

Question 10

Which continent has the highest number of companies?