The J.M. Smucker Co. Interview Questions

The J.M. Smucker Co. Interview Guides

Click or hover over a slice to explore questions for that topic.
SQL
(3)
Machine Learning
(3)
Behavioral
(2)
Statistics
(1)
Product Sense & Metrics
(1)

The J.M. Smucker Co. Interview Questions

Practice for the The J.M. Smucker Co. interview with these recently asked interview questions.

QuestionTopicDifficulty
SQL
Medium

Given a employees and departments table, select the top 3 departments with at least ten employees and rank them according to the percentage of their employees making over 100K in salary.

Example:

Input:

employees table

Columns Type
id INTEGER
first_name VARCHAR
last_name VARCHAR
salary INTEGER
department_id INTEGER

departments table

Columns Type
id INTEGER
name VARCHAR

Output:

Column Type
percentage_over_100k FLOAT
department_name VARCHAR
number_of_employees INTEGER
SQL
Hard
SQL
Hard
Loading pricing options

View all The J.M. Smucker Company questions

Challenge

Check your skills...
How prepared are you for working at The J.M. Smucker Company?

Discussion & Interview Experiences

?
There are no comments yet. Start the conversation by leaving a comment.

Discussion & Interview Experiences

There are no comments yet. Start the conversation by leaving a comment.

Jump to Discussion