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

French Employment Exercises

This exercise contains the information about the French employment. The table datasets.french_employment_base_etablissement_par_tranche_effectif provides information about the establishments present in a town while datasets.french_employment_net_salary_per_town_categories presents the net salary per town.

Question 1

Which town has the most companies (employment opportunities)?

Question 2

What is the average number of firms in a town?

Question 3

What is the French town’s mean net salary (economy condition)?

Question 4

Which town has the most mean net salary for middle manager?

Question 5

Which age range makes the most money in the largest city (Paris)?

Question 6

Which age range by gender makes the most money? How about in a much smaller city(48 firms, Marzan)?

Question 7

What is the breakdown of small to large firms in the town with the most firms (Paris)? How about in Marzan?

Question 8

What is the relationship between Total_Firms and Female Executive Salaries in Towns? What is the relationship between Total_Firms and Male Executive Net Mean Salaries in Towns? What is the relationship between Total_Firms and Male Executive Net Mean Salaries in Towns?

Note:

SNHMFC14 : mean net salary per hour for feminin executive

SNHMHC14 : mean net salary per hour for masculin executive

Question 9

What is the relationship between Big500_Firms and Female Executive Salaries in Towns? What is the relationship between Big500_Firms and Male Executive Salaries in Towns?

Note:

E14TS500 : number of firms with more than 500 employees in the town

Question 10

What is the relationship between Total_Firms and Female (18-50) Net Mean Salaries in Towns? What is the relationship between Total_Firms and Male (18-50) Net Mean Salaries in Towns?

Note:

NHMF2614 : mean net salary per hour for women between 26-50 years old

SNHMH2614 : mean net salary per hour for men between 26-50 years old