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

Basic SQL Exercises 2

Instructions

Questions

1. List all companies working in finacials sector which are headquarted in Europe or Asia.

Schema: datasets

Table: forbes_global_2010_2014

Hints:

2. Find the most profitable company from the financials sector in the entire world. What continent is it from?

Schema: datasets

Table: forbes_global_2010_2014

Hint:

3. For each sector find the maximum market value and order the sectors by it. Which sector is it best to invest in?

Schema: datasets

Table: forbes_global_2010_2014

Hints:

4. How are companies distributed among countries considering only the best sector from previous question?

Schema: datasets

Tables: forbes_global_2010_2014

Hints:

5. Which industry shows profit on average while having the lowest sales of all industries?

Schema: datasets

Table: forbes_global_2010_2014

Hints:

6. How many users speak English, German, French or Spanish?

Schema: datasets Table: playbook_users

Hints:

7. Find the id of companies which have more than 10 users which are not speaking English, German, French or Spanish.

Schema: datasets

Table: playbook_users

Hints:

Schema: datasets

Table: playbook_users

Hints:

9. Find the company with a highest number of users which has a difference of more than 365 days between first and last activation dates.

Schema: datasets

Table: playbook_users

Hints:

10. What is the language breakdown for the company from previous question?

Schema: datasets Table: playbook_users

Hints: