Progressive Leasing Interview Questions

Progressive Leasing Interview Guides

Click or hover over a slice to explore questions for that topic.
Data Structures & Algorithms
(95)
SQL
(75)
Machine Learning
(68)
Probability
(41)
Product Sense & Metrics
(31)

Progressive Leasing Interview Questions

Practice for the Progressive Leasing interview with these recently asked interview questions.

QuestionTopicDifficulty
SQL
Medium

To finish a class, students must pass four exams (exam ids: 1,2,3 and 4).

Given a table exam_scores containing the data about all of the exams that students took, form a new table to track the scores for each student.

Note: Students took each exam only once.

Example:

For the given input:

student_id student_name exam_id score
100 Anna 1 71
100 Anna 2 72
100 Anna 3 73
100 Anna 4 74
101 Brian 1 65

the expected output should be:

student_name exam_1 exam_2 exam_3 exam_4
Anna 71 72 73 74
Brian 65 NULL NULL NULL

Input:

exam_scores table

Column Type
student_id INTEGER
student_name VARCHAR
exam_id INTEGER
score INTEGER

Output:

Column Type
student_name VARCHAR
exam_1 INT
exam_2 INT
exam_3 INT
exam_4 INT
Business Case
Medium
Analytics
Hard
Loading pricing options

View all Progressive Leasing questions

Challenge

Check your skills...
How prepared are you for working at Progressive Leasing?

Progressive Leasing Salaries by Position

Data Scientist*
$135K
Data Scientist
Median: $135K
Mean (Average): $135K
Data points: 1
ML Engineer*
$120K
ML Engineer
Median: $120K
Mean (Average): $120K
Data points: 1
Product Manager*
$105K
Product Manager
Median: $105K
Mean (Average): $105K
Data points: 1

Most data science positions fall under different position titles depending on the actual role.

From the graph we can see that on average the Data Scientist role pays the most with a $135,000 base salary while the Product Manager role on average pays the least with a $105,000 base salary.

Discussion & Interview Experiences

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