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

Intermediate SQL Exercises

This exercises help you master the intermediate level concepts.

Questions

1. Make a report showing the number of survivors and nonsurvivors per passenger class.

Schema: datasets

Table: titanic

Hints:

2. How are survivors distributed by gender and passenger class?

Schema: datasets

Table: titanic

Hints:

3. What is the age of oldest survivor per passenger class?

Schema: datasets

Table: titanic

Hints:

4. Show the team divisions per player.

Schema: datasets

Tables:

Hints:

5. Find the average player height per division.

Schema: datasets

Tables:

Hints:

6. Show user language breakdown per country.

Schema: datasets

Tables:

Hints:

7. How many events happened on mac book in Argentina from users which are not speaking Spanish? What language are they speaking?

Schema: datasets

Tables:

Hints:

8. For each language find the number of users who prefer apple products. Assume apple products are only macbook pro, iphone 5s and ipad air.

Schema: datasets

Table:

Hints:

9. How many logins Spanish speakers made per country?

Schema: datasets

Table:

Hints:

10. Tabulate occurence counts for a list of event names along with the number of days between their occurence and the registration date of the user.

Schema: datasets

Tables:

Hints: